Search results

Access does not have an option to sort alphanumeric strings properly with the result that sorting a column with the following (sort of) data is almost impossible. Flat A1 Flat A10 Room A13 Room A2 Room A21 B5 Flat 5b 10k1 10 k3 10 k12 10 k20 10 k2 etc I need to be able to get addresses sorted...