Sort numbers in a text field

[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.

 

[Cheryl Fischer]

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,