Microsoft ACCESS REPORT HELP. PLEASEEE

[Guest_imported]

I need to know how to add a calculated field in a report to add a column of values

My report is using a query
I have a calculated field in the query to calculate COST.

[OrderQty]*[SellPrice]=Cost

Now In my report I need to calculate a TOTAL of all the COST fields for each item.

Please help me. I hope I have made sense.
'
Cheers
Aaron

 

[richieuk]

Repeat the calculation i.e. =Sum([OrderQty]*[SellPrice])

 

[PaulF]

Depends on how the query/report is laid out. If all items appear as one record, then using the sum on the same line and summing all of the Fields will do. If there are more than one record to be summed together, then look into Grouping, and adding a textbox in the Groups Footer to display the result. Then again if a Total cost of all items in all Groups is required, then look into placing a textbox in the Report Footer, and sum all of the Group Total textboxes.

PaulF