Query Question

[aporkalypse_now]

Please forgive my ignorance as I am learning more by the day.

I have created a query that has tracked duplicates by company name and shows the total spent per order. Is there any way I can get a grand total for all orders to show up in this query? I have looked at the help files but it really did not describe where to find all the tools

Thanx to all

 

[chrismcbride]

You can not display the sum of fields within a query, however you easily can show the sum if you make a Report and base in on the initial Query. Add a calculated control the summs the values of any set of controls you want and away you go...
Chris