Sort numbers in a text field

  • Thread starter Thread starter TY
  • Start date Start date
T

TY

How do I sort numbers in a text field? For example, my
sort is comming back as 1-10-11-2-3-33-4 etc. I need it
to come back as 1-2-3-4-10-11-33 etc.
 
Presuming you are doing this in a query and that the values in your text
field begin with numeric values, you can use:

NumSort: Val([MyTextField])

Then, set the Sort: row in the query to Ascending or Descending

hth,
 
Back
Top