Hi, at the moment I have this query:
SELECT Feedback, Exercise_Class_ID, Count(*) AS Total_Per_Exercise_Instructor
FROM tblExerciseClass
WHERE (((tblExerciseClass.Feedback) Between '0' And '1')) AND (((tblExerciseClass.Date_Exercise_Class) Between '02/01/12' And '03/01/12'))
GROUP BY Feedback, Exercise_Class_ID;
I want to include the name of the exercise instructor from tblExerciseInstructor in the above query. The name of the field = Full_Name. In the tblExerciseInstructor, each Exercise_Class_ID represents an exercise instructor (i.e. EC00001 is taught by Thomas Howard). The query shown above is just from tblExerciseClass. How do I do this?
Many thanks.
SELECT Feedback, Exercise_Class_ID, Count(*) AS Total_Per_Exercise_Instructor
FROM tblExerciseClass
WHERE (((tblExerciseClass.Feedback) Between '0' And '1')) AND (((tblExerciseClass.Date_Exercise_Class) Between '02/01/12' And '03/01/12'))
GROUP BY Feedback, Exercise_Class_ID;
I want to include the name of the exercise instructor from tblExerciseInstructor in the above query. The name of the field = Full_Name. In the tblExerciseInstructor, each Exercise_Class_ID represents an exercise instructor (i.e. EC00001 is taught by Thomas Howard). The query shown above is just from tblExerciseClass. How do I do this?
Many thanks.