Sort listing error

  • Thread starter Thread starter Lee Brown
  • Start date Start date
L

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
 
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
 
Back
Top