Count total records by date

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.

--
Novice Access User

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]) ;

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"DSpencer" wrote:

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.

--
Novice Access User