Count unique students at report footer

  • Thread starter Thread starter Song Su
  • Start date Start date
S

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?
 
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
 
Song said:
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?
Click to expand...

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