Solved

Counting number of records by ID number  - Access -2007

Posted on 2011-02-18
2
287 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:morinia
2 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 34929226
SELECT Table1.ID, Count(Table1.enrollment date) AS EnrollDateCount
FROM Table1
GROUP BY Table1.ID;

mx


0
 

Author Closing Comment

by:morinia
ID: 34929258
Perfect!!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Office 365 home questions 7 65
VBA Access 2016 syntax 6 40
backup programme - VBA 3 22
Update a text value in another table 10 36
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now