Delete Duplicates Query

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hello,

Does anyone know how to delete duplicate records thru a query when the
information is stored as followed:

ACCOUNT CHECK CHECK_AMT PAY_AMT ESCROW
205922 1104 6734 6734 0
205922 1104 6734 6734 0
205922 60268 6734 6734 0
205922 60268 6734 6734 0
203266481 31 2870.75 2870.75 815.18
203266481 31 2870.75 2870.75 815.18
203266481 32 2870.75 2870.75 815.18
203266481 32 2870.75 2870.75 815.18

This is just a small example. I have thousands of records that need to be
deleted due to duplicate outputs on a very inefficient query build years ago.

Any help would be great. Otherwise I may have to continue pasting into
excel; an extremely tedous process that I figured out.
 
Please disregard the previous post. I figured it out by simple recreating my
table and making the account and Check my primary keys. An append query to
the new table removed any duplicates on for each record.
 
Back
Top