By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,212 Members | 1,210 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,212 IT Pros & Developers. It's quick & easy.

I want to create a query in Access 2013 that shows the number of students per class

P: 1
I have a table called "Students" and in this table I have their student ID, which is also the unique identifier number, along with first and last name and grade. I also have an "Enrollment" table which has the class unique identifier associated with the students linked to the Students table and the "Courses" table. The enrollment table show each student and the class they are assigned to. How do I create a query to show the number of students per class?
Apr 22 '15 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,430
Do a count on the enrollment table and group by the class id
Apr 22 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.