tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Access: Only show unique values in a query in Access 2007

See solution in other versions of Access:

Question: In Microsoft Access 2007, I've created a query and I only want to display the unique values. How do I do this in Access?

Answer: Open your query in design view. Right-click somewhere in the Query window beside a table (but not on a table) and select Properties from the popup menu.

Microsoft Access

When the property editor appears, make sure that the top of the editor says:

Microsoft Access

Set the "Unique Values" property to Yes. Then close the property editor by clicking the X in the top right corner.

Microsoft Access

This property is specific to the query that you are working on. So you will need to repeat the same steps on each query that you wish to display unique or distinct values.