johnlatona123
Innovator
- Local time
- Today, 12:19
- Joined
- Sep 20, 2011
- Messages
- 85
how do i create a totaling query that results in monthly totals?
available fields:
date
category
amount
available fields:
date
category
amount
query by month
- Thread starter johnlatona123
- Start date
stopher
AWF VIP
- Local time
- Today, 19:19
- Joined
- Feb 1, 2006
- Messages
- 2,388
You can create a query with some new fields:
ReportYear: Year([myDate])
ReportMonth: Month([myDate])
Once you have these fields you can easily change the query to an aggregate query and sum on these two fields.
Note that Date is a reserved word in Access so you should avoid having a field called Date (hence I've used myDate).
hth
Chris
ReportYear: Year([myDate])
ReportMonth: Month([myDate])
Once you have these fields you can easily change the query to an aggregate query and sum on these two fields.
Note that Date is a reserved word in Access so you should avoid having a field called Date (hence I've used myDate).
hth
Chris
