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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer