Undo an Append Query

[Guest]

I have accidently appended the information from one table into another
several times. I was wondering if there is an easy way of deleting all the
excess records?

 

[Lynn Trapp]

If there is something that would uniquely identify the records that were
appended mistakenly, youcould use that to filter a delete query. If not,
then you might try running a Distinct query to see if that returns only the
records you need. If it does, then you can use that as a Make Table query
for creating a new table.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html