B
Brucels
Windows Explorer (Windows XP) sorts a group of files as follows:
1995.203.22.1.tif
1995.203.22.2.tif
1995.203.22.3.tif
1995.203.22.4.tif
1995.203.22.5.tif
1995.203.22.6.tif
1995.203.22.7.tif
1995.203.22.8.tif
1995.203.22.9.tif
1995.203.22.10.tif
1995.203.22.11.tif
1995.203.22.12.tif
The same group, entered in an Access 2002 table (with the field formatted as
a text field), sorts as follows:
1995.203.22.1.tif
1995.203.22.10.tif
1995.203.22.11.tif
1995.203.22.12.tif
1995.203.22.2.tif
1995.203.22.3.tif
1995.203.22.4.tif
1995.203.22.5.tif
1995.203.22.6.tif
1995.203.22.7.tif
1995.203.22.8.tif
1995.203.22.9.tif
Is there any way of changing the Access sort to match the Explorer sort
without having to manually insert zeroes?
Thanks,
Bruce
1995.203.22.1.tif
1995.203.22.2.tif
1995.203.22.3.tif
1995.203.22.4.tif
1995.203.22.5.tif
1995.203.22.6.tif
1995.203.22.7.tif
1995.203.22.8.tif
1995.203.22.9.tif
1995.203.22.10.tif
1995.203.22.11.tif
1995.203.22.12.tif
The same group, entered in an Access 2002 table (with the field formatted as
a text field), sorts as follows:
1995.203.22.1.tif
1995.203.22.10.tif
1995.203.22.11.tif
1995.203.22.12.tif
1995.203.22.2.tif
1995.203.22.3.tif
1995.203.22.4.tif
1995.203.22.5.tif
1995.203.22.6.tif
1995.203.22.7.tif
1995.203.22.8.tif
1995.203.22.9.tif
Is there any way of changing the Access sort to match the Explorer sort
without having to manually insert zeroes?
Thanks,
Bruce