>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.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison