We have school photos in folders on our network drives. Each student has a unique 6-digit ID and about 10-20 photos (jpgs). We need a small program to 1. Find a unique ID, then take the third photo with that id and copy it another a folder. Then, the program looks for the next unique ID and copies the third photo with that ID into the same folder... when the program is finished, there should be one photo for each student in the new folder, and it should always be the third photo found.
Should be pretty simple.
Need to be a small user interface that can browse to whichever folder (and subfolders) need to be looked through. Sometimes there will be 40 students, sometimes there will be 3,000.
This should be written in Microsoft Access 2003 (that's all we have) or some other software we don't have to purchase...