Reports: Formula for grand total of several values?

ecorg911

Registered User.
Local time
Yesterday, 16:30
Joined
Jan 7, 2009
Messages
14
Hi, I currently have to add up all values of the "Total" field in my query and then implement a "Grand Total" value on my report.

The formula for "Total" is:

Total Amount Payable: [Quantity]*[Unit Price]

In this case, what would be the formula to add up all of the values (in the "Total" field.)?

Any help would be greatly appreicated.

Many Thanks
 
The easiest way would be a textbox in the report footer with a control source of:

=Sum([Total Amount Payable])

I would not use spaces in the alias name.
 
Thanks worked like a charm :)
 

Users who are viewing this thread

Back
Top Bottom