# How to Use Distinct Values MS Access

> To use distinct values in MS Access, go to the Create tab and select Query Design. Add your query and click Add Selected Tables. Open the Property Sheet, set the Unique Values property to Yes, and click the Run button to execute the query.

Canonical: https://livedemo.ai/tutorials/how-to-use-distinct-values-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a516aab56e05a00ffe2bf/preview?step=1

## Steps

1. Go to the 'Create' tab.
2. Select 'Query Design'.
3. Add the query you want to use and click 'Add Selected Tables'.
4. Open the 'Property Sheet', Set the 'Unique Values' property to 'Yes'.
5. Click the 'Run' button to run the query.