Count unique items

Ambre

New member
Local time
Today, 15:05
Joined
Feb 11, 2010
Messages
9
Hi,

I have a table of enrolments. Each row is a single enrolments by a Learner on a course in a Curriculum Area. A Curriculum Area can have a number of different types of courses eg. CurrArea Languages offers French, German and Italian and a Learner could join one or more courses in any or all of the languages offered.

I need to query:
  1. How many enrolemnts in CurrArea Languages.
  2. How many unique Learners in CurrArea Languages.
  3. How many enrolemnts in French.
  4. How many unique Learners are studying French.
1 and 3 are no problem - I use 'group by' and 'count' on the relevant columns, but how do I do 2 and 4?

Thanks,
Ambre
 
For #2 take out the currArea and group/count by learner
for #4 enter ="French" in the condition line under CurrArea
 

Users who are viewing this thread

Back
Top Bottom