Sort listing error

[Lee Brown]

I am having trouble with the correct sort list. I have a reference no from say 001D through to 1000D.
When I request for the column to sort - it is very good until 999D then the following numbers are sort listed in with the 100 numbers.
I need to sort so that the whole list is in numerical order. Any ideas.
In the table I have a format for this item as : #"/>@"

When I have tried to edit this, all the changes fail and the code reverts to the same as before.

Any help would be gratefully received


Best regards

Lee

 

[Ken Snell]

Numbers that are text are sorted as text not as numbers. With your setup,
it'll be easy to do what you seek. Add a calculated field to the query:
SortOrder: Val([FieldName])
And sort this field in ascending order. That should do it for you.


--
Ken Snell
<MS ACCESS MVP>

I am having trouble with the correct sort list. I have a reference no from
say 001D through to 1000D.
When I request for the column to sort - it is very good until 999D then the
following numbers are sort listed in with the 100 numbers.
I need to sort so that the whole list is in numerical order. Any ideas.
In the table I have a format for this item as : #"/>@"

When I have tried to edit this, all the changes fail and the code reverts to
the same as before.

Any help would be gratefully received


Best regards

Lee