Counting number of records by ID number - Access -2007

I have an access database that look like the attached Excel spreadsheet.  It has two fields an ID number and an enrollment date.

I would like to know how to count the number of enrollment dates within each member.


enrollment.xlsx
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
SELECT Table1.ID, Count(Table1.enrollment date) AS EnrollDateCount
FROM Table1
GROUP BY Table1.ID;

mx


0
 
moriniaAdvanced Analytics AnalystAuthor Commented:
Perfect!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.