Summary Queries

[trawets]

Hi
Currently I have a db where I can run queries on several locations
( from a form with a drop down list) which in turn runs a query then
puts out results to a report which is summed in the footer.
My question is how do I write a query which will look at each
location, total the cost of items for each location, then put out a
list of locations with total costs for each.
Then I can do as before put results to a report a sum in the footer
I hope this is clear enough to understand, any advice would be greatly
appreciated

 

[trawets]

Hi
Currently I have a db where I can run queries on several locations
( from a form with a drop down list) which in turn runs a query then
puts out results to a report which is summed in the footer.
My question is how do I write a query which will look at each
location, total the cost of items for each location, then put out a
list of locations with total costs for each.
Then I can do as before put results to a report a sum in the footer
I hope this is clear enough to understand, any advice would be greatly
appreciated

Hi again
I am sorry to have posted this, it was a lot easier than I thought,
A little research and a bit of thinking sorted this no problem
Thanks for reading anyway