Help with sorting values in a lookup wizard

[BWPS104]

Hi
So I have a simple table in Access and one of the columns has multiple value look up wizard. When I produce a query, I need to select multiple values from the look up wizard. My question, is how to I get these values to appear in the order they are listed in the look up wizard (instead of alphabetical order).

Thanks!

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[SHANEMAC51]

Hi
So I have a simple table in Access and one of the columns has multiple value look up wizard. When I produce a query, I need to select multiple values from the look up wizard. My question, is how to I get these values to appear in the order they are listed in the look up wizard (instead of alphabetical order).

Thanks!

it is enough to have an additional RANG field in the TABLE, which is filled in for selected positions, the rest may be empty

the request

select * from spr_city order by nz(rang,999) ,naim_city

9

 

[oleronesoftwares]

So I have a simple table in Access and one of the columns has multiple value look up wizard. When I produce a query, I need to select multiple values from the look up wizard. My question, is how to I get these values to appear in the order they are listed in the look up wizard (instead of alphabetical order).

Welcome @BWPS104 to the best online forum for Ms Access developers.

Do you have a sort by column?
What order do they appear in the lookup wizard?
Where do you want the values to appear?