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