Count in report not query

[Guest]

Hello

I have a report that shows what services a student has used. The services
are displayed as counted check boxes with the students name.

I want to count the number students in the report, but I only now how to
count the total from the query that report is based on. So for instance their
miight be 10 students on the report, but the total in the report footer will
show 384.

I currently have a textbox in the report footer with the a control of
=count([lname]), if someone could help me correct this to display the total
corrrectly.

Thank you

 

[Marshall Barton]

I have a report that shows what services a student has used. The services
are displayed as counted check boxes with the students name.

I want to count the number students in the report, but I only now how to
count the total from the query that report is based on. So for instance their
miight be 10 students on the report, but the total in the report footer will
show 384.

I currently have a textbox in the report footer with the a control of
=count([lname]), if someone could help me correct this to display the total
corrrectly.

Create a group with header on the student field using the
Sorting and Grouping window (View menu). Then add a test
box named txtStudentCount to the group header section. Set
its control source to =1 and its RunningSum property to
Over All.

Then set the report footer text box's ecpression to
=txtStudentCount