unique values

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

I am using a query for a control on a combo box. How can I specify that my
query only select unique values. I have a table of counties by zip
code--clearly each county is listed a multitude of times--and I only want my
combo box to list each county once.

Thank you for any assistance.

LB
 
In the design view of your query, right click in any blank area in the top
half of your query and select properties. Change the Unique Values property
from No to Yes.
 
Lauren said:
I am using a query for a control on a combo box. How can I specify that my
query only select unique values. I have a table of counties by zip
code--clearly each county is listed a multitude of times--and I only want my
combo box to list each county once.

Thank you for any assistance.

LB
Click to expand...
SELECT DISTINCT ColName
FROM Table

Hth
PerL
 
Back
Top