Count unique students at report footer

[Song Su]

I have a report to list students with scholarship applications. Since each
student can apply multiple scholarships, (thus same student may appear more
than once on the report), I want to create a textbox at report footer to
count unique student ID (SID). How to do it without sub-report?

 

[Duane Hookom]

There are a couple options:
1) create a query that groups by and then counts the unique student. Include
this count query in your report's record source query.
2) Add a text box to the Student Group Header
Name: txtCountStudents
Control Source: =1
Running Sum: Over All
Visible: No
Add a text box in the report footer section
Control Source: =txtCountStudents

 

[Marshall Barton]

I have a report to list students with scholarship applications. Since each
student can apply multiple scholarships, (thus same student may appear more
than once on the report), I want to create a textbox at report footer to
count unique student ID (SID). How to do it without sub-report?

If the records are grouped by SID, then you can use an =1
running sum text box in the SID group header or footer. The
report footer text box can then use the expression like:
=[running sum text box]

If you don't have a SID group header or footer, create one
and make it invisible.