How can I find records with duplicate entries in their first two fields?

[LordJezo]

Say I have a table with the following fields..

A | B | C | D | E | F

What I want to do is the following..

Find and display all rows in which the fields A and B are the same. It dosent matter to me what entries are in C, D, E, and F.

So if one entry was

hoover | Frank | foo | bar | etc..

it would match up with

hoover | Frank | khrkh | something | anything


Should be easy to do but I can't figure it out! Please help!!

 

[dcx693]

Have you tried the Find Duplicates Query wizard?

 

[LordJezo]

How do I get to the duplicate wizard? Help says:

"In the Database window, click Queries under Objects, and then click New on the Database window toolbar."

But I see nothing anywhere labeled "Objects"!

 

[Mile-O]

How do I get to the duplicate wizard? Help says:

"In the Database window, click Queries under Objects, and then click New on the Database window toolbar."

But I see nothing anywhere labeled "Objects"!

On the query tab there's the New, Design, or Open menu. Select New, a box pops up. Find Duplicates is in this menu.