How do I perform this query?

[Tsung90]

Hi, I need to perform a query to produce a report, I have to answer this question 'who is the favourite class instructor this month?'

In my tblExerciseClass:

Column 1: Exercise_Class_No

Column 2: Exercise_Class_ID = each exercise class has an Instructor_ID and each exercise instructor teaches a specific class (e.g. dance, martial arts, etc), each exercise instructor will have an Exercise_Class_ID. Each Exercise_Class_ID = 1 specific class an instructor teaches.

Column 3: Member_ID

Column 4: Full_Name

Column 5: Date_Exercise_Class

Column 6: Time_Exercise_Class

Column 7: Feedback

To create this query I was thinking to use Exercise_Class_ID in this table and to see which Exercise_Class_ID appears the most in the table as they can be repeated, as many members and non-members attend the classes. Is this the best way it can be done?

Thanks.

 

[PNGBill]

Create are normal Select Query with the important fields.
When it displays all the data you believe there should be, click the Totals Button and use Group and Count accordingly.

Count will of course give you the number of records for each Group - Teacher.

Sort Order on the field you are Counting and the first record is the Favourite Teacher.

You may need to do this with two queries.