# Running a query to display only unique fields

**URL:** <https://forum.kirupa.com/t/running-a-query-to-display-only-unique-fields/257080>\
**Category:** programming\
**Created:** [April 10, 2008, 1:37am UTC](https://forum.kirupa.com/t/running-a-query-to-display-only-unique-fields/257080 "2008-04-10T01:37:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![angryscrub](https://avatars.discourse-cdn.com/v4/letter/a/58956e/32.png) [@angryscrub](https://forum.kirupa.com/u/angryscrub)\
**Post date:** [April 10, 2008, 1:37am UTC](https://forum.kirupa.com/t/running-a-query-to-display-only-unique-fields/257080/1 "2008-04-10T01:37:29Z")

</div>

I’m drawing a total blank on this. I’ve tried various search terms, but come up dry.

Basically what I need to do is figure out how to do a drop down menu that displays only the unique values in a certain field in a recordset (using dreamweaver cs3, asp, and an access database). IE, I want to display all the unique zip codes in the zip code field. If 33333 shows up a hundred times in the database, I only want to see it once, and every other zip code only once, no matter how many times each is in the database. Could someone point me to a tutorial on something like this? I’m sure it’s pretty straight forward, but I can’t seem to find anything, and I can’t even figure out how to approach it.

Maybe after some sleep I’ll do better, but any help would be much appreciated!