>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

thanks that works insofar as it gives me an inventory of the data and how many of each record has the same data
so one result was as follows
1 with 1010
1 with 1014
2 with 1019
2 with 1031
how would i simply extract 4 out of this and hold it as a variable?