Retrieving Duplicate Fields... (1 Viewer)

[Emohawk]

Hi,
Simple one here. I have a table with loan numbers and the associated loan information stored. What I need to do is pull every record where the loan number has been duplicated.
Cheers.

 

[Jack Cowley]

Take a look at the Find Duplicates Query Wizard.

 

[Emohawk]

Thanks... I thought the wizard was only over two tables, but was wrong. Finally worked it out though (my server was down so I couldn't check the response) I got the same result from writing a query that joined the table to itself and then searching for indentical loan numbers with differing keys.