SELECT COUNT(xrc), xrc FROM TheTable GROUP BY xrc

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