urjudo

asked on

# query sort by digit

Hi Experts,

I have a question about sorting numbers in a query. I have box# from 001 to 11339, when I tried to do a query using ascending on box#, it gave me from 001 to 1122 then 11220, 11221 etc to 1123 then 11231. is anyway that I can sort from three digit to four digit to five digit?

Thanks

I have a question about sorting numbers in a query. I have box# from 001 to 11339, when I tried to do a query using ascending on box#, it gave me from 001 to 1122 then 11220, 11221 etc to 1123 then 11231. is anyway that I can sort from three digit to four digit to five digit?

Thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

with the way that op described the problem and the leading zeros, this is definitely a text field.

ASKER

you both were right, it's a text field.

ASKER

I tired Rey's suggest, it works. Thanks a lot both!!!