Just thought I would jump in here with the one millionth suggestion :):
SELECT COUNT(DISTINCT StudentID)
lnDistinctCount = _TALLY
>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.
Chris McCandless
Red Sky Software