Duplicate check on 2 fields

[richmarin@earthlink.net]

I am using Access 2002

I have the following task. I have to do a duplicate check on two
fields. The logic is, for a given day, and a given id, how many
managers shared that same ID on that day. Example data below

Date ID Manager
01/01/05 123 Tom
01/01/05 123 Bill
01/01/05 456 Larry

So, using the data above. The query should return a count of 2 for day
01/01/05 for id 123. Why, because Tom and Bill shared the same ID on
the same day.

How can I do the above?

...

[jv]

Re: Duplicate check on 2 fields

SELECT Date, ID, count(Manager) FROM TableName GROUP By Date, ID