Creating Queries in Access 2010
- Introducing Query Types
- Creating a Query Using the Query Wizard
- Editing a Query in Design View
- Using Criteria to Focus Query Results
- Introducing Operators
- Using Queries to Calculate Values
- Creating a Parameter Query
- Finding Duplicate Records
- Finding Unmatched Records
- Writing Query Results to a New Table
- Creating an Update Query
- Creating a Crosstab Query
- Finding the Largest and Smallest Values in a Field by Using a Query
Finding Duplicate Records
The standard select query locates records that meet a criterion, such as orders made by a particular customer during a given month. However, you might also be interested in finding those customers who placed more than one order in a month. If all orders for a month are recorded in the same table, you could create a Find Duplicates query to locate CustomerID values that occur more than once in the table.
Create a Find Duplicates Query
Click the Create tab.
Click Query Wizard.
Click Find Duplicates Query Wizard.
Click the table in which you want to find duplicate information.
Click the field that might contain duplicate information.
Repeat steps 7 and 8 to add any other fields to the query.
Click any other field you want to display in the query results.
Repeat steps 11 and 12 as necessary.
Type a name for the query.