Reports: Formula for grand total of several values?

[ecorg911]

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

 

[pbaldy]

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.

 

[ecorg911]

Thanks worked like a charm