Count duplicates (1 Viewer)

[y2k]

Sorry, that's not a very good descritpion of what I want to do, but it's the best I could come up with!! I have a table called MasterTable upon which all of the queries within my database are based on. Within the MasterTable there are two fields (well there's more ... but I'm only concerned with these two right now ). Plan Number and Claim Number. In a query, I've created a new field as follows

NewFieldName: ([Plan Number]&"-"&[Claim number])

My problem is, what I'd really like to do is, rather than return Plan Number-Claim Number - I'd like to return the amount of times the value was found in the table. So, for example if Plan 123 Claim Number 456789 appeared twice, I'd like to return a 2 instead of 123-456789. How would I go about doing that, without chaning the query to a crosstab query? I'm sure this is possible, I'm just a little bit of a novice in Access so I need some help.

Thanks in advance!!

Edit
I forgot to mention, if this required using two fields instead of one, that wouldn't be a problem

 

[Mile-O]

A couple of ways depending:

i) Lookup the DCount() function;

ii) Use the query wizard to make a find duplicates query