Repost: Single result listing

  • Thread starter Thread starter Daniel
  • Start date Start date
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
 
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)
 
Back
Top