Summary Queries

  • Thread starter Thread starter trawets
  • Start date Start date
T

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
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
Click to expand...

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
 
Back
Top