How to create a Report Sum on an calculated column in Access

Michael Paravicini
Michael Paravicini used Ask the Experts™
on
I use a report with grouping and would like to add a group subtotal on a column which is computed the following way:

=GetTitelGV([TypeOfInvestment];[QTY];[EINSTAND];[xMarkt])  -> name of the column is xTitelGV

at the end of each Subsection I would like to show the subtotal using =Sum([xTitelGV])

However, this does not work. I don't want to use =Sum(GetTitelGV([TypeOfInvestment];[QTY];[EINSTAND];[xMarkt])) as I am using external API calls which are pretty slow.
Thank you so much for any help. Best regards Michael
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try to rename field in report to хxTitelGV, for example, and sum new name
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
Are you running this function:

GetTitelGV

in the ControlSource of the textboxes?  If so, why not just include it as part of the query?

Author

Commented:
Thank you to both of you. The easiest was to include the changes in the query... Best regards Michael

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial