Recent content by StrugglingWithAccess

damn, I didn't even notice that. Thank you so much, really grateful.

Hi sorry I am still struggling. I now have this, I have renamed the date field as suggestedSELECT TBL_Lesson.LessonName, Count(TBL_Lesson.LessonName) AS [Times Completed], TBL_Lesson.LessonLevel, TBL_Class.ClassDate FROM TBL_Class INNER JOIN (TBL_Lesson INNER JOIN TBL_RegistrationofClass ON...

have created a query that counts the number of times a pupil has attended a lesson. It tells me the total of how many each pupil has had but when I add a date range to the query it ungroups the data again. I have added the lesson name field into the query and used count on the 2nd one like I...