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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using field name as value in query 2
How to eliminate rows with redundant values and keep other values? 1
summing population by zip and by county together 3
Need help sorting out ANDs and ORs in parameter query 2
return only last records query 3
query based on form 2
Return "yes" or "no" if value in one field matches any value in ot 7
Unbound Combo Box Displays Fields based on a Relationship - how to? 1

Back
Top