Duplicates Finder | Access Add-in
Typical Scenario
Your table is full of duplicate records with each duplicate set containing multiple records. However, you are not sure which fields contain those duplicate values. You want to identify those duplicate fields by querying your table several times using a different combination of fields as criteria. You then query your table for duplicates using the duplicate fields. Your next task is to edit the non-duplicate fields of the first/last instance of each and every duplicate set based on the other records in the set. Finally, you can delete other instances of duplicates in each duplicate set, ending up with only unique records.
Key Features
1. Duplicates Finder works like Access’ Find Duplicates Query Wizard. You can use this five step self-explanatory add-in with no training.
2. With Find Duplicates Query Wizard, you just get all your duplicate records, making it hard to distinguish among different instances of the duplicate records in each duplicate set, when you are trying to edit or delete your records if your table does not include a unique numeric field. Duplicates Finder automatically adds an AutoNumber field to your table if one is missing, enabling you to easily identify particular instances of duplicates.
3. Duplicates Finder provides 12 different ways to query your table, facilitating your task of identifying, editing, and removing all duplicate records from your table quickly and efficiently.
4. Find Duplicates Query Wizard also comes in handy when you need to identify the first or last order by each customer (Use a customer name field as a duplicate field).
5. You can either get your query results in a datasheet view or make a table out of the results or delete your filtered data.
6. You can adapt the 12 query techniques used for this add-in to your own needs.
7. Duplicates Finder overcomes a Find Duplicates Query Wizard’s shortcoming: With Find Duplicates Query Wizard, if you do not select additional fields to display on top of your duplicate fields, you end up getting a list of first instances of duplicates as opposed to all instances of duplicates! With Duplicates Finder you do not have to select additional fields.
How It Works
Step 1: Open your database and click Tools>Add-Ins>Duplicates Finds from the menu bar to open Duplicates Finder.
Step 2: Select a table from the list.
_______________
Step 3: Select your duplicate fields from the list.
Tip: If you include a field with null values, you may end up getting fewer duplicates than you expected. Select the field in the next step, if you still want the field displayed.
_______________
Step 4: Select additional fields to display.
_______________
Step 5: Indicate how you want your table queried by selecting one of the 12 choices.
_______________
Step 6: Indicate what you want to accomplish with your input:
Create a query, delete duplicates or make a table.
Also modify the given query or table name, if you wish.
We offer an unconditional 30-day Money Back Gurantee and free e-mail support! Your order is secured via RegNow SSL Secure Server (see RegNow Security/Privacy statement). You will be able to download the product immediately after ordering!
|
