Duplicate entry

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hello,

I am using Access 2002 and I am trying to find all the duplicate policy
numbers in the Policy Number field in one particular table. My question is
how do I get the duplicate policy number to show in the query. For example
I may have policy # AB101, policy # AB101, policy # AB101 I just want to
show the last two duplicates so I can review and delete them. Any tips or
help will be appreicated. Thank you.
 
The easiest way is to use the built-in "Find duplicate" wizard in access.

To use this, select queries in the left panel, then click "New" in the menu
bar located in the database window (not the Access toolbars). You will see a
short list of queery types. Select "Find Duplicate Query Wizard" and follow
the prompts.

When you finish building the wizard, it will show you all duplicates (all
three in your examle). It is up to you to decide which two to delete. I
recommend you add a few other columns of data to see if one is "better" than
the others. Then you can delete the other two.

Let me know if this helps.

Randy
 
Randy,

Thanks for your help I wanted something that was simple and easy. Again
thanks.
 
Back
Top