>does anyone have a clever way of doing this?
>I have a collection of records with a field called Xcr.
>In a table of 20 records, sometimes all the xcr's are identical, most of the time there are 2-5 different entries.
>i would like a code to tell me what that number is.
>
>
>thanks
>k
How about

SELECT COUNT(DISTINCT xcr) FROM myTable