Drop List Question

[cwhite]

It has been a long time since I last used access so forgive me if this
question is bit pedestrian.

There is a table with a list of entries in the name field like this:

tom
tom
dick
harrry
tom
dick
dick

if I create an access form with a drop-list to display these names it
will show them exactly like this:

tom
tom
dick
harrry
tom
dick
dick
what I want it to do is display the list like this (alpanetized,
descending and filtering out multiple instances of the same name)

dick
harry
tom

Where can i find information on how to do this? Or does someone have a
quick explanation they can share with me? (I'm using access 2000)

Thanks

[Allen Browne]

Set the RowSource of your list box to:
SELECT DISTINCT [Field1] FROM [Table1] ORDER BY [Field1];
replacing Field1 and Table1 with the name of your field and table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"cwhite" <cw****@theatomicmoose.ca> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

It has been a long time since I last used access so forgive me if this
question is bit pedestrian.

There is a table with a list of entries in the name field like this:

tom
tom
dick
harrry
tom
dick
dick

if I create an access form with a drop-list to display these names it
will show them exactly like this:

tom
tom
dick
harrry
tom
dick
dick
what I want it to do is display the list like this (alpanetized,
descending and filtering out multiple instances of the same name)

dick
harry
tom

Where can i find information on how to do this? Or does someone have a
quick explanation they can share with me? (I'm using access 2000)

Thanks

[cwhite]

Cool!

I'll give it a try.

Thanks a lot.

[cwhite]

Thanks a lot, it worked like a charm, it wasn't displaying the names in
the list, but after looking your instructions I realized if I wrote it
as:

SELECT DISTINCT [Table].[Field], [Table].[Field] FROM Table ORDER BY
[Field];

it would display the names.

Thanks again!!!