How to Use Distinct Values MS Access

Quick summary

The Distinct Values property in MS Access Query Design lets you eliminate duplicate records from query results by setting Unique Values to Yes in the Property Sheet. This five-step process uses the Create tab and Query Design view to return only unique rows from any selected table or query.

Steps

1. Go to the Create tab in MS Access.
2. Select Query Design to open the query design view.
3. Add the query you want to use and click Add Selected Tables.
4. Open the Property Sheet and set the Unique Values property to Yes.
5. Click the Run button to execute the query and return distinct values.