using count function in a query

[y2k]

please, can somebody help me? This sounds pretty simple, but I can't get it to work. Am I correct in saying that Access has a built in "count" function for counting the amount of occurrences of a certain value in column? anyway, that's basicly what I want to do. So I have a field called Claim Number. How can I create another field in a query that will look through this field and return a 1 if a value is present once, a two if a value is present twice and a three if a value is present three times etc etc etc like so:
Claim Number Times
123456 2
546879 1
652014 1
602154 2
123456 2
802546 1
602154 2


Any help would be so greatly appreciated

 

[DonkeyOte]

you mean something like

SELECT COUNT(CRITERIAFIELDNAME) FROM TABLENAME WHERE CRITERIAFIELDNAME = 'CRITERIA'