I need to count the records from a table using a certain field that has some duplicates in it. I don't want each duplicate to be counted separately but as one. I can't use a 'group by' or I'll just get a long result set instead of one number. Is there some way of doing a count query off of the group by query? Maybe using some sort of subquery?