I have a table with student ids. Some ids
occur more than once. I'd like a count at the
bottom of the report of UNIQUE ids, not just
the number of records.

Say there are 100 records, but only 86 unique ids.
I'd like the '86' to show in my total field.

Any suggestions? For now, I just ran another query
and used a separate table with that one number to
place it there. This seems sloppy.