SELECT MyField, COUNT (*) as Cnt FROM MyTable GROUP BY MyField

HTH

>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?