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

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" <cwhite@theatomicmoose.ca> wrote in message
news:1137779873.367898.76630@o13g2000cwo.googlegro ups.com...[color=blue]
> 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
>[/color]

Cool!

I'll give it a try.

Thanks a lot.

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!!!