I have a folder that has dwg files in it and I would like to organized by
last 2 digit of file name, any suggestions?
Would you like to do so in an Access Database (the subject of this newsgroup)?
If so you can indeed do so with the help from a little bit of VBA code. You
could create a Table with a Text field for the filename, and perhaps a second
indexed field for the last two characters. Make this an Integer field if the
last two digits are in fact digits, Text if they are alphanumeric.
You can then use VBA code using the Dir() function to retrieve the filenames
from Windows and store them i
