Access to 196 free guest articles, discussions and more, just create your free OfficeUsers User ID:

Email address:

This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Ferreting Out Near-Identical Records in Access

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.

Article Abstract:

(Ken Bluttman) Working with lists of contacts is a common database activity. As a list grows, the probability of duplicate records increases. They could be exact duplicates, which are easy to find by running a duplicates query. In Access, the Find Duplicates Query Wizard is great for finding exact duplicates based on selected fields. This wizard is available in the New Query dialog box. On the Queries tab, click on the New button and the dialog appears; see Figure 1.

Read this article...

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content
No Comments/Feedback Posted Yet. Post Your Comments/Feedback

[ Register ] [ Webcasts ] [ Podcasts ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to OfficeUsers ] [ Recent Orig. Content ]
© 1997-2009, Bits on the Wire, Inc.

Some names and products covered by OfficeUsers are the registered trademarks of their respective owners.