filtering, i guess that's it

[enriquemellado]

hi
hope someone can help.
I'm making a form to select country/state/city for members
i made a table with 3 columns country,state,city

i wrote down the states for 2 countries (the ones i'm gonna use)
the city is left blank (since i don't want to write down all the cities just yet)

i'm looking to do:

When i try to display the Country as a drop down using a query that selects the column for country, i get a list of the same country the amount of times it is in the table for each state.
I only want to see each country once. even though in the table it is written several times.

 

[The_Doc_Man]

Your best bet is to drive the drop-down from a summation query that counts the incidences of each country. I don't think you can do this directly from a drop-down because I believe a drop-down wants to do a direct access to a single value, and from your description, that won't happen from your table.

 

[enriquemellado]

just thought i'd post this.

i found the answer...
in case someone else comes to the same problem.

i made a query that takes the values from the table with the countries/states/cities

SELECT DISTINCT locationtable.[countrycolumn]
FROM locationtable
ORDER BY locationtable.[countrycolumn];

by adding the word DISTINCT it makes sure the values are not repeated.

hope this is helpful for someone..
thanks a lot for your help