Stupid Ques...How can I limit a query so that no dups are displayed?

[dquin656]

Hi-

I have a table of zip codes and cities. I use a query in back of my form for a drop down list. There is no problem with the zip codes, cause there aren't any duplicates, but there are when I try to do the same with the city. Example: Chicago may have 20-50 zip codes....,

How can I get my select query to only display "Chicago" (as and example) only once, instead of for every zip code in the table?

I used to know how to do this, and it is driving me NUTS trying to remember how to do it.

Thanks in advance,

Deb Q in Chicago
Senior Applications Developer
(Just getting back into Access(2000))

 

[Ouch]

i remember this one

in query design ther is a icon on the toolbar that looks like a "E" click this and select "group by" in the totals line that has appeared

 

[Mute101]

Just put a DISTINCT into your SQL and you will only get each instance once.

ie. "SELECT DISTINCT CityName FROM tblCities"

Regards
Simon

 

[dquin656]

Thanks gents...I knew there was an easy answer...

Debra Q in Chicago