Calculate multiple records (1 Viewer)

[monk_1987]

If anyone can help it would be awesome!! Anyway...

I run my own music tuition business and I want to be able to do take an annual record attendance score for each customer/pupil, just so I can see who is the worst and best attendant etc.

I currently have a system where I take a register of attendance and that lesson information.

I have a dcount function to work out the percentage of an individual attendance which works great.

The problem is, I want to be able to click a button and it runs through all of my pupils individual attendance records so I don't have to click on each individual to do it. Is this at all possible? Any help would be greatly appreciated!

Thanks in advance

Rhys

 

[Pat Hartman]

Use a query. It will look something like this:

Select StudentName, Year(LessonDate) as LessonYear, Count(*) As AttendedCount
From YourAttendanceTable
Group By StudentName, Year(LessonDate);