Hello,
I have a field in my database which consists of an alpha-numeric code. These codes are not created internally but are provided by external resources and as such I cannot change them. The problem I am getting is the sorting of records in reports, combo boxes, etc.
For example, the first sequence in the field is A-S0 to A-S13. However, in the report the records are listed as follows
A-S0
A-S1
A-S10
A-S11
A-S12
A-S13
A-S2
A-S3 and so on up to A-S9.
Is there any way I can have these records sorted in the correct order with A-S10 to A-S13 listing after A-S9?
I have a field in my database which consists of an alpha-numeric code. These codes are not created internally but are provided by external resources and as such I cannot change them. The problem I am getting is the sorting of records in reports, combo boxes, etc.
For example, the first sequence in the field is A-S0 to A-S13. However, in the report the records are listed as follows
A-S0
A-S1
A-S10
A-S11
A-S12
A-S13
A-S2
A-S3 and so on up to A-S9.
Is there any way I can have these records sorted in the correct order with A-S10 to A-S13 listing after A-S9?
Alphanumeric Sort Order
0 commentaires:
Enregistrer un commentaire