by harshvar on March 20th, 2006

harshvar

Question

Help answer this question below.

How can I delete duplicate entries from a table without losing the data?

Answers. 1 helpful answer below.

  • by Mushen on November 18th, 2006

    Mushen

    In access: copy the table.

    Create a Find Duplicates Query (wizard).
    Create a Delete Query
    Create Update Query

    Create a macro to run 3 queries together.
    Look in Help - it will tell you step by step what to do

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

You're reading How can I delete duplicate entries from a table without losing the data?

Follow us on Facebook!

Related Ads

ANSWERBAG BUZZ

Why do toenails get thick
Macro access 2002 remove duplicate entries