Count total records by date

  • Thread starter Thread starter DSpencer
  • Start date Start date
D

DSpencer

I Have a table containing names, age, id number, and date of entry.
I would like to count the total number of records by month on a report.
 
Do you want Dec, Jan, Feb, Mar, etc. or Dec 09, Jan 10, Feb 10...

In other words do you just want by Month or Month and Year? Also what
version of Access?

Open up a new query in design view, but don't add any tables to the grid.
Instead go to View, SQL View and paste in the following. Change the field
names to what's correct and YourTable to the correct table name.

SELECT Month([date of entry]), Count(ID)
FROM YourTable
GROUP BY Month([date of entry]) ;

or

SELECT Year([date of entry]), Month([date of entry]), Count(ID)
FROM YourTable
GROUP BY Year([date of entry]), Month([date of entry]) ;
 
Back
Top