Hi, this should be easy but I'm really confused by it. I'm a pretty experienced Access user and have not seen this before. I have a short-text field storing numbers with digits, spaces, and decimals. I initially imported the data from a spreadsheet. Some of the data looks like this:
11 00 00
11 00 01
11 00 02
11 00 03
12 00 00
12 00 01
12 00 02
12 00 03
12 00 04
12 00 05
When I try to add a new record, it is not sorting it correctly like the following list:
11 00 00
11 00 01
11 00 02
11 00 03
12 00 06
12 00 07
12 00 08
12 00 00
12 00 01
12 00 02
12 00 03
12 00 04
12 00 05
The new entries I add for the 12 series come after the 11 series but before all the numbers I imported from the spreadsheet.
Any ideas for me?