Get a list of unique values in a table

In an Access database you can easily get a list of the unique values in a column by running a SQL command.


  1. This table contains multiple entries for many city names:



2. To get a deduped list go to Create . . . Query Design, and select 'SQL View' at the left of the toolbar.


3. Enter the following SQL command:

SELECT DISTINCT Olympics.City

FROM Olympics


The command SELECT DISTINCT picks a field in a table, and then FROM pulls that field from a designated table.


4. Click Run, and a new query will be generated listing each value in the table only once: