Calculate Totals in Query Based Report

[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

 

[Newbie]

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

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?

 

[Samantha Rawson via AccessMonster.com]

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'

 

[Samantha Rawson via AccessMonster.com]

Sorry, found the problem: the code doesn't work in a page footer, only the report footer. Works perfect now, thanks for the help.