Counting # of values in a group registration

[UnknownJoe]

I have a small DB that keeps track of community events, where people can
enroll and attend various courses. Each course is entered into the DB as well
as each enrolled individual, with name, age, etc, but most importantly, the
individual's Province. For example, Course DF102 - Gardening, has 20 people
enrolled, with each person having the same or different province (BC, AB,
ONT, MB, etc).

What I would like to do is be able to generate a query that lists each
course, and within each course, identify (count) the number of individuals
from BC, the # from AB, etc, etc, in order to break it down for statistical
purposes.

Example: DF102, Gardening, Count (BC) = 10, Count (AB) = 8, Count (SK) = 2

Thanks,
J.L

 

[ghetto_banjo]

create a new query, and enable the "Totals" option (you can right
click in the query and choose this). Link your Course and Student
tables (or however you have it set up).

Choose Course, Province, and StudentID (or whatever) for your fields.
The "totals" option for both Course and Province should be set to
"Group By". The "totals" option for StudentID should be set "Count".

This will return the information you are looking for, aye.