Logo
HOW TO
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
 
 
Windows 7

Microsoft Access 2010 : Creating Queries - Finding Duplicate Records

6/8/2012 6:25:35 PM
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.

1. Create a Find Duplicates Query

  1. Click the Create tab.

  2. Click Query Wizard.

  3. Click Find Duplicates Query Wizard.

  4. Click OK.

  5. Click the table in which you want to find duplicate information.

  6. Click Next.

  7. Click the field that might contain duplicate information.

  8. Click Add.

  9. Repeat steps 7 and 8 to add any other fields to the query.

  10. Click Next.

  11. Click any other field you want to display in the query results.

  12. Click Add.

  13. Repeat steps 11 and 12 as necessary.

  14. Click Next.

  15. Type a name for the query.

  16. Click Finish.

Other -----------------
- Microsoft Outlook 2010 : Viewing Message Participant Information
- Microsoft Outlook 2010 : Configuring Reading Pane Behavior
- Deep Dive: Windows Home Server Features (part 2) - Remote Access
- Deep Dive: Windows Home Server Features (part 1) - PC Backup and Restore, Document and Media Sharing
- Microsoft Visio 2010 : Containers and Lists (part 2) - Lists
- Microsoft Visio 2010 : Containers and Lists (part 1) - Containers
- Microsoft Visio 2010 : Creating rule set reports - Getting the XSL stylesheet
- Microsoft Access 2010 : Using Queries to Calculate Values & Creating a Parameter Query
- Microsoft Access 2010 : Using Criteria to Focus Query Results & Introducing Operators
- Microsoft Excel 2010 : Changing Summary Calculations, Showing and Hiding Data Items, Sorting Your Pivot Table
 
 
REVIEW
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
 
VIDEO TUTORIAL
- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
Top 10
- Microsoft Excel : How to Use the VLookUp Function
- Fix and Tweak Graphics and Video (part 3) : How to Fix : My Screen Is Sluggish - Adjust Hardware Acceleration
- Fix and Tweak Graphics and Video (part 2) : How to Fix : Text on My Screen Is Too Small
- Fix and Tweak Graphics and Video (part 1) : How to Fix : Adjust the Resolution
- Windows Phone 8 Apps : Camera (part 4) - Adjusting Video Settings, Using the Video Light
- Windows Phone 8 Apps : Camera (part 3) - Using the Front Camera, Activating Video Mode
- Windows Phone 8 Apps : Camera (part 2) - Controlling the Camera’s Flash, Changing the Camera’s Behavior with Lenses
- Windows Phone 8 Apps : Camera (part 1) - Adjusting Photo Settings
- MDT's Client Wizard : Package Properties
- MDT's Client Wizard : Driver Properties
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro