Thanks I'm also thinking of creating a variable and a function that will add 1 to it on the "Run Expression: On Entry" of the group header
I think it might work
BDH
>>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.
>
>bernardo, I often use the SQL SELECT... INTO ARRAY and use it in the report, so there is no need in separate table.
B.D.H.