How do I sort a text field such as:
1.0
2.2
13.9
Instead of:
1.0
13.9
2.2
Thanks
How do I sort a text field such as:
1.0
2.2
13.9
Instead of:
1.0
13.9
2.2
Thanks
You would probably need to add a calculated field that converts your entry to number, and then sort on this calculated field.
That calculated would look something like:
CDbl([MyField])
Just what I needed - Thanks
How do I close this as being answered?
Just marked it as "Solved", like you did.How do I close this as being answered?