Access Newbie - Query for Daily Subtotals?

[malikastor]

Hi All,



Recently got turned on to Access and I'm really enjoying learning about it. I hope you can help me, since it has to do with my new years resolution to be better about my finances!

I have a table in which I am recording all of my purchases called Expenses, with the following fields:

• Date
• Description
• Amount
• Payee
• Category

I would like to create a query that I can run for a particular month that will show me how much I spent in total on each day. So for example, if I had 3 transactions on Jan 1 with each at $5, I would want the result set to display 1/1 - $15 and so on for all the days in Jan. I would like this query to be flexible enough so that I may use it for any month I wish, as I hope to incorporate it into a report somehow. I'm really interested in learning SQL, so a SQL query response would be appreciated!



Your help is much appreciated, I hope I can return the favor one day!

[pbaldy]

Unless you're in a web db, a totals query is going to be your solution. Start a query with the date and amount fields in it. In design view, click on the Totals icon on the ribbon. Change Group By to Sum on the Totals row for the amount field and run the query. Presuming that's what you're after, the next thing to look into is parameter queries, like this person:

https://www.accessforums.net/reports...ter-20044.html

[malikastor]

Thank you Paul!

As you've probably guessed, I'm not on a web DB.

I'll check out the link you provided me.

[pbaldy]

No problem, and welcome to the site. Post back if you get stuck.