Removing Duplicate Records in Access
Well, I know Access isn't really a
Newbie kind of program, but this IS Linda's Office Tips, so I guess I
need to throw in something about Access every once in a while for the
Newbies who are forced to use it at work.
So, here's a good one. Do you
find that your Access Database is cluttered with duplicates? If
so, in Your Database Window, make sure you have "Queries"
selected in the Object Bar on the left and click on the "New"
button at the top and select the "Find Duplicates Query
Wizard".
This will walk you through selecting
the table or query where the duplicates are located, then selecting all
of the fields that might have duplicate information. It's easy to
use and works well. The biggest problem is that most people don't
know where to find the Wizard or that it even exists if they aren't used
to creating Queries.
So, now you are in the know!
Hang in there!
Linda
Hang in there!
Linda
Visit
Linda's web site
Write
to Linda about her tips
| Back
to Top | Back
to Tips Archive | Home
Page |
Ü
Sign Our Guestbook
Copyright
© 2001 Roglan International LLC All Rights Reserved
