Order by

Any way to stop access ordering numbers incorrectly

Please see attached
Capture6.PNG

Microsoft Access

Last Comment

Gustav Brock

8/22/2022 - Mon

n2fc

10/15/2016

It is using an alphabetic sort instead of numeric... You would have to change the contents of that field to use a 2 (or 3 digit, if the number portion exceeds 99) after the letter!

Derek Brown

10/15/2016

ASKER

How do you change to numeric?

Derek

Gustav Brock

10/15/2016

Specify this:

Order By Val(Mid([Door Number],2))

/gustav

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

Derek Brown

10/16/2016

ASKER

If I have

DS6ST and
DS4ST it does not order correctly. Is it possible to order this correctly? Bearing in mind the user could enter any number of alpha numeric combinations

Derek Brown

10/16/2016

ASKER

Gustave

Your suggestion worked well on my previous example

ASKER CERTIFIED SOLUTION

Gustav Brock

10/16/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial