Sort records on numeric values stored in a text field

[phuongkhanh3045]

Hi - I would like to be able to sort a field that is currently defined as text so that the user is able to enter "player numbers". There are people who have number that are 00, 1, 30, 0, 4, 22 etc... But when I tried to sort this field in a report, the order is not correct numbericallly. Any help would be appreciated. Thanks.

 

[pbaldy]

You'll have to create a sorting field using Format(FieldName, "00") where the number of zeros is the maximum number of characters.

 

[phuongkhanh3045]

Thank you for the info but can you give me the details of what I need to do step by step. Thanks.