By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 1,534 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 IT Pros & Developers. It's quick & easy.

Duplicate check on 2 fields

P: n/a

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?


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
SELECT Date, ID, count(Manager) FROM TableName GROUP By Date, ID

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.