If you want just the records for one month of one year, and you want to
specify the month and year when the query runs:
1. In the Criteria row under your Date/Time field, enter this (all on one
row):
= DateSerial([What year (4-digit)], [What Month (1-12)], 1)
And < DateSerial([What year (4-digit)], [What Month (1-12)] + 1, 1)
2. Choose Parameters on the Query menu.
Access opens the Parameters dialog.
Enter 2 rows:
[What year (4-digit)] Integer
[What Month (1-12)] Integer
The query will now ask for a year and month number when you run the query.
Or perhaps you wanted the query to give you totals for each month, instead
of just the records for one month? We will assume your date/time field is
named MyDate for this example:
1. Depress the Totals icon on the toolbar in query design.
(Upper sigma icon.)
Access adds a Total row to the grid.
2. Type this into a fresh column in the Field row:
Year([MyDate])
Accept Group By in the Total row.
Choose Ascending in the Sort row.
3. In the next column, in the Field row, type:
Month([MyDate])
Accept Group By in the Total row.
Choose Ascending in the Sort row.
4. Drag the field you want to total into the grid.
In the Total row under this field, choose:
Sum
This query gives you a total by month.
how to Query a Date Field to Return all records within a month period ?
e.g. Jan (return all records within Jan)
Feb (return all records with Feb)
So on...