Comparing query

[Novice]

Hi
I need to write a query in access to compare multiple records against a user and then see if another user has the same records.
This is in a fantasy football database. All users have picked particular teams. I would like to somehow see if any two or more users have picked identicle players.
There must be a query I could set up to show mw this?
Thanks
Novice

 

[bat17]

A lot is going to depend on your data structure. you may be able to use the "Find Duplicates" query wizard to find any duplicates

Peter