Unanswered: Modify a field's value for sorting in a report?
I have a database which has a field called "Location". The values entered in this field are in one of two formats:
where A is a letter and # is a number.
Now, for sorting purposes, this doesnt work, because if you have these two entries:
1A32 and 1A4, it wants to sort by putting 1A32 before 1A4. However, for my purposes, 1A4 should go before 1A32. My question is, how can I modify these values for display in a report? I don't want to modify the original entries in the database, just change the format so that they will sort correctly in a report.