Sort Ascending numerically?

  • Thread starter Thread starter Steve Thomas
  • Start date Start date
S

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.
 
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.
 
Back
Top