Count the students per month in a report (Access 2000)

Topic

New Reply

I want to count the number of the students in my report.How can i do it ?
My report is formated for the months view,on the field LastUpdated, the LastUpdated Header.
=Format$([LastUpdated];”mmmm yyyy”;0;0)

In the details section i have the list of the students.How can i count the number of the students
for each month ?

Reply | Quote

Replies

In the detail section add a textbox with control source =1 (with equal sign). Set the visible property to false and the Running Sum to Over Group. Name it Counter.
In the Group Footer of LastUpdated add a text box with control source = Counter. This will give you the count of the students for each month.

Reply | Quote

In the detail section add a textbox with control source =1 (with equal sign). Set the visible property to false and the Running Sum to Over Group. Name it Counter.
In the Group Footer of LastUpdated add a text box with control source = Counter. This will give you the count of the students for each month.

Reply | Quote

As an alternative to Francois’ solution, you can put a text box in the group footer for LastUpdated with control source =Count(*)

Reply | Quote

As an alternative to Francois’ solution, you can put a text box in the group footer for LastUpdated with control source =Count(*)

Reply | Quote