By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,077 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Drop List Question

P: n/a
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

Jan 20 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jan 20 '06 #2

P: n/a
Cool!

I'll give it a try.

Thanks a lot.

Jan 25 '06 #3

P: n/a
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!!!

Jan 25 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.