count for each month

J

jac007

Is there a way to do the following? Have a count for each month so if I
recieved 3 documents in January I would have a count till 3 and if its a new
month the count will start over? Please help, thanks!

Column A Column B
1 1/2/2006
2 1/2/2006
3 1/6/2006
1 2/4/2006
2 2/8/2006
3 2/12/2006
4 2/12/2006
 
A

Allen Browne

1. Create a query using this table.

2. Type this into the Field row in query design:
TheYear: Year([Column B])

3. In the next column of the Field row, enter:
TheMonth: Month([Column B])

4. Depress the Total button on the toolbar.
Access adds a total row to the grid.
You will see "Group By" in the Total row under both of those columns.

5. Drag [Column A] into the grid.
In the Total row under this field, choose Count.
 
Top