How to Remove Duplicates From Access Query

Written by emmanuelle douglas
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Remove Duplicates From Access Query
Remove duplicates from an Access query by using the Unique Values option. (pregunta image by caironbohemio from Fotolia.com)

Use Access to work with volumes of data in a database. Access lets you convert massive data into queries and report. The queries let you ask a question of the data in your database. Use the query criteria to get the exact results you are looking for. When removing duplicates, use the Unique Values attribute to return only distinct values in your query.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Use Access to work with volumes of data in a database. Access lets you convert massive of data into queries and report. The queries let you ask a question of the data in your database. Use the query criteria to get the exact results you need. When removing duplicates, use the Unique Values attribute to return only distinct values in your query.

Show MoreHide

Instructions

  1. 1

    Open an Access 2007 database on your computer. Make sure it has a table that contains duplicate data. Select the "Office" button and select "Open." Search your computer and locate the database. Click on the database and select "Open."

  2. 2

    View the tables in your database in the Navigation Pane. Open one of the tables and visually note the duplicates and note the total number of records. Select the "Create" tab on the ribbon. Click on the "Query Design" button. Add the table you have just viewed by clicking on the table and selecting "Add." Select "Close." Add some fields to the query by double clicking on the fields.

  3. 3

    Select the "Properties" option by right clicking in the grey area of your query design field. This will display the Properties Sheet dialogue box. Locate the "Unique Values" field. Change the field to "Yes."

  4. 4

    Run the query by clicking on the "Run" button. The query will return the distinct values from the table. This is due to the Unique Values field being changed to Yes. Save the results by clicking on the "Save" icon on the Quick Access Toolbar.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.