Sort Ascending numerically?

[Steve Thomas]

I'm sorry if this has been asked here dozens of times before...I'm sure it
has!
But would someone please tell me how do you get a table to list numerically
as in 1 2 3 etc. instead of 1 10 11 etc
Thanks for your help,
Steve.

 

[Allen Browne]

In Table Design, set the Field Type to Number instead of Text.

If that is not possible for some reason, you could sort in a query by
creating a calculated field using Val([MyField]), and sorting on that.