Repost: Single result listing

D

Daniel

Hello,

How can I make a query on a specific field of a column so that it return all
the values of the field but without showing duplicate entries?

When I retrieve the listing from my table I get

orange
red
yellow
orange
yellow

I would like to only retrieve a listing of all the entries but without
duplication, such as:

orange
red
yellow

Thanks in advance,

Daniel
 
V

Van T. Dinh

In the DataSource pane (top pane) of your Query, right-click on an empty
space and select Properties to get the Query Properties Dialog. Change the
"Unique Values" Property to Yes / True.

This is equivalent to using the keyword DISTINCT in the SQL String. Check
Access Help (JET SQL Reference "book") on the keyword DISTINCT.

HTH
Van T. Dinh
MVP (Access)
 
Top