Search results

  1. N

    Find latest date imbedded in filename within specific folder

    I have a backup directory with the the date in the filenames to mark when a database was backup-ed. I want to search the directory and return the filename with the latest backup date. (Not last modified date) Format looks like this (always) FileName_mmddyyyy.accdb Thus in C:\BackupDbDir...
  2. N

    Sort text feild by numbers, numbers and letters, then letters

    I have data that has numbers, numbers and letters and letters and numbers in a text field. Looks like this 1,1a, 13a, 14a, 15o, PP23, PP23a, 2,44, AB3 Needs to sort like this: 1, 1a, 2, 13a, 14a, 15o, 44, AB3, PP23, PP23a I used the val(fieldname) function in an Access 2010 query field and it...
Back
Top Bottom