delete duplicates from a duplicate querey

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many duplicates in a table after running a duplicate querey. I want
Access to tell me how to delete just the duplicate rows.
 
Arnold,

It is actually easier to use a Select query on the table and activate
Totals so you get unique records only, change that into a Make Table
query and produce a new table without duplicates, then get rid of the
original one and rename the new one to the original name.

Tip: back up before you try anything!

HTH,
Nikos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

entering criteria for a parameter querey 1
>=[BeginDate] And <=[End Date] 1
Ordering crosstab querey columns 3
Deleting Duplicates 2
How do I place the return value from a querey into a text box cont 1
Best Gmail Backup Tool to use in 2025? 3
deleting duplicate records obtained from a duplicate query 4
Access Auto Matching Duplicates? 0

Back
Top