Sort numbers in a text field

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

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Linking Child Timelines to Multiple Parents 0
Sorting and filtering text 0
Using FIND to highlight text (with dashes) 4
Word- Find and Replace 1
Link a text box based on drop down box with four options MS Word 365 0
Incremental 1, 4, 7, 10, 2

Top