Recent content by Wyndham

Just thought I'd give an update. We have abandoned trying to do this in Access and have sorted the data in Excel and then imported the results back into Access. It really is disappointing that Access doesn't have the ability to sort something like addresses properly. After all this can't be...

Little progress The linked article/discussion was very interesting but unfortunately didn't solve the problem, or maybe it did and I just didn't see it..... I was however intruiged by the GetString and GetNumeric in the attached query but unfortunately my version of Access 2000 doesn't have...

Many thanks Many thanks for the quick responses. The data content actually comes from a government body which provides all address data in the UK and we have to deal with it as it arrives. The list displayed is unsorted and the results should be that 2 follows 1 and goes before 10, etc. I...

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...