Hi,
I have aproblem with a field in one of my tables.
The field is called LibraryNumber.
The problem is that when I put and A-Z sort on the field the numbers are not in the order I'd like them to be, for example:
1
12
13
134
20
22
255
3
35
As you can see they are not 'really' in numerical order. 20 really comes before 134 etc.
Each number really consists of 5 digits, e.g.:
1 should read 00001
134 should read 00134
How do I get the zeros in front???
Do i need some kind of imput mask?
Will the numbers then be in numerical order?
Anoher problem: The data already exists in the data base and there are about 20,000 records....so changing anything by hand really isn't an option!
Can anybody help???
TIA
I have aproblem with a field in one of my tables.
The field is called LibraryNumber.
The problem is that when I put and A-Z sort on the field the numbers are not in the order I'd like them to be, for example:
1
12
13
134
20
22
255
3
35
As you can see they are not 'really' in numerical order. 20 really comes before 134 etc.
Each number really consists of 5 digits, e.g.:
1 should read 00001
134 should read 00134
How do I get the zeros in front???
Do i need some kind of imput mask?
Will the numbers then be in numerical order?
Anoher problem: The data already exists in the data base and there are about 20,000 records....so changing anything by hand really isn't an option!
Can anybody help???
TIA