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

nope for some reason i am getting the number 3 consistency through out. tnx k