Access Sorting

[Derek]

Probably a stupid question, but I have an Access Database and a numerical
column. I am trying in a query to have that column sorted ascending, but
Access puts 10-19 before 2, and 20-29 before 3. How can I change this so
it's in the proper order?

Thanks

 

[Bob I]

10-19 isn't numerical, it is text, and sorting text will put it in that
order.

 

[databaseben]

02 & 03

one way to fix is that:

you can export the table or import it to excel
and do a format or use a formula to fix the data
in that column. Then reimport the table back
into access for use...

thre are other ways too..... but you get the idea