Help Dropdown

[Emine]

Hi Everyone, I know that this must have happened to someone else, but for the
life of me I cannot find it anywhere. Sorry for the repeat in question. OK
anyways, here is my problem.

I imported an Excel spreadsheet into Access. The spreadsheet contained
multiple same name of Hotels, Airport Codes and Training : Example:

Hotel Airport Code Training
Hilton LAX Coach
Hilton LAX Coach
Hilton LAX Coach
Hilton LAX Coach
Marriott JAC Engage
Marriott JAC Engage
Marriott JAC Engage


Drop Down I want is something like this: (Show item only once not multiple
times)

Hilton Lax Coach
Marriott Jac Engage


Is there a way I can trim (I think thats the proper word) where Hilton is
not repeated multiple times? I just want it listed as Hilton once so that
the user can select Hilton and not see Hilton listed over 500 times? Same
applies for all other fields.

I just need a simple dropdown that list each field name once. Can some
please tell me what it is I need to do? Thank you so much

 

[M Skabialka]

Add the word DISTINCT to your combo query
"SELECT DISTINCT mytable.Hotel, .... FROM ... WHERE ... " etc

 

[Emine]

Thank you so much for responding!!! Where exactly do I add this? Is it in
the properties of the combo box or query? Not sure where to write it.