How to Query for Unique Records in Access 2007
Access 2007 is part of the Microsoft Office Suite. It comes standard with the professional and ultimate packages of Microsoft Office 2007, but you may also purchase Access separately. When querying a database for unique records, it is important to understand how Access 2007 selects the unique records. Within this program, "unique values" will only look in the fields selected for the query, while "unique records" will look in all the fields.
Other People Are Reading
Instructions
-
-
1
Open the database in Access 2007. Click the "Create" tab.
-
2
Click the "Query Design" button.
-
-
3
Select your table, and then click "Add" in the "Show Table" window.
-
4
Drag each of the fields you want in the query from the table window to the bottom of the screen where "Field" is located.
-
5
Click in the blank space next to the table window, and then click the "Property Sheet" button from the ribbon. Select "Yes" next to "Unique Values" to check just the fields selected for the query, or select "Unique Records" to check all fields. In other words, "Unique Values" could remove entries that are unique to the table if the values of the fields in the query match another entry.
-
1
