Calculate Totals in Query Based Report

  • Thread starter Thread starter Samantha Rawson via AccessMonster.com
  • Start date Start date
S

Samantha Rawson via AccessMonster.com

I have a report based on the results of a query. The query (and therefore the report) asks the user for the Order ID then displays all part orders (items) and their costs. Is their a way to add all these together?

Ask if that's unclear...

Any help would be appreciated,

Samantha Rawson
 
Have a look at Grouping and setting a Footer at OrderID and adding a textbox
with the formula
=sum(txtQty) - or whatever your you fields are called
Samantha Rawson via AccessMonster.com said:
I have a report based on the results of a query. The query (and therefore
Click to expand...
the report) asks the user for the Order ID then displays all part orders
(items) and their costs. Is their a way to add all these together?
 
My field is 'Total' and I wish to add the totals together to get a grand total. I typed in =Sum([Total]) yet produced '#Error'
 
Sorry, found the problem: the code doesn't work in a page footer, only the report footer. Works perfect now, thanks for the help.
 
Back
Top