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