Hi all,

Is there a way of counting for the number of distinct values in a field.
I need to find out the number of different codes in a field and dont really want to do a SELECT DISTINCT into a different table and count the number of records. Anyone any ideas?

Thanks,

Ger