Search results

  1. S

    Query when date criteria added count is lost

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

    Query when date criteria added count is lost

    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...
  3. S

    Query when date criteria added count is lost

    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...
Back
Top Bottom