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:
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 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