Move files based on MS Access query match
Posted on 2014-11-27
Hi, I need to move and rename PDF files if the existing filename matches a database query. My query has a result called case_num. Where the case_num matched the name of a PDF file in a known folder, I want to move it to another location and add the suffix "_original", the .pdf.
I've been struggling with this for a little while now so your help would be most appreciated.