.svg){kind=icon}
.gif)
.svg)
Here’s how to do it:
- Go to the 'Create' tab.
- Select 'Query Design'.
- Add the query you want to use and click 'Add Selected Tables'.
- Open the 'Property Sheet', Set the 'Unique Values' property to 'Yes'.
- Click the 'Run' button to run the query.
How to Use Distinct Values MS Access
Use this interactive demo to learn how to utilize distinct values in Microsoft Access.
📌 Why this matters
Removing duplicate records from your query results prevents skewed calculations and ensures accurate data analysis. When you're working with related tables that create multiple rows for the same entity, duplicate values can inflate counts, throw off averages, and create misleading reports.
Beyond cleaning up your immediate results, using distinct values becomes essential when building more complex queries or feeding data into forms and reports. This technique also improves performance by reducing the dataset size that Access needs to process and display.
Your product deserves an interactive demo
Similar Articles
No items found.