I'm not sure how to make a query do what I need to. Basically I have a Sales table with Date, Name, Location and Total Sales. I want to be able to get a grand total for all Sales on a certain date by location. I'm not sure how to make this work the way I want.
So basically let's say I have:
09/21/09 | Aaron | A Location | $1
09/21/09 | Sarah | A Location | $2
09/21/09 | Bob | B Location | $5
I want to get the output:
09/21/09 | A Location | $3
09/21/09 | B Location | $5