Access: create summary queries with the count option

preview_player
Показать описание
How to create summary queries in Access to count fields (or find the sum, average, max, min....)
Рекомендации по теме
Комментарии
Автор

what if i got a table name enrollment which has a FK of student id and class id , how to i limit the enrollment of a class to only 15 students ?

jamespui
Автор

how do I know if how many the total number of registered students whose active and how many whose inactive using ms access.

jamesandrew