T
Tony
I have data in a field that can comprise numbers or letters and numbers eg:
Serial
1234
4567
0456
N01234
N00123
A45987
Each of these serial numbers belongs to a seperate item of inventory, What i
want to do is sort them in number order for reports that are required.
I cannot get them to sort correct, the ideal outcome is they be sorted from
the right ie in the correct sequennce, the problem is some have leading zeros
and some have leading letters characters.
Using a memo field doesnt work, I cant use Number for the format as it will
delete the records with letters characters. the desired outcome is below
SERIAL
0456
1234
4567
N01234
N00123
A45987
Serial
1234
4567
0456
N01234
N00123
A45987
Each of these serial numbers belongs to a seperate item of inventory, What i
want to do is sort them in number order for reports that are required.
I cannot get them to sort correct, the ideal outcome is they be sorted from
the right ie in the correct sequennce, the problem is some have leading zeros
and some have leading letters characters.
Using a memo field doesnt work, I cant use Number for the format as it will
delete the records with letters characters. the desired outcome is below
SERIAL
0456
1234
4567
N01234
N00123
A45987