Calculating Totals

[Beenz75]

I am calculating the total sales using the formula, in a new field;

Total Sales: ([Quantity]*[Price])+[postage]

This works fine and adds up the totals of each individual sale. But, what I really want to show is the grand total of all sales (the total of all figures in the new "Total Sales" Column)

Thank you

 

[pbaldy]

Typically you would do that on the form or report you're displaying the records on. If you really want both the detail records and the total in the query, you'll need to union together a totals query with your detail query.