How can I move files from one location to another.
I currently have files that are produced every month and 'sent' to specific folders. I would like to be able to then move these to another folder at the end of the month so that only the current month reports are available in the original folder
Before new reports are 'sent' to the below folder
S:\Statement of Expectations\General Staff\Finance Office
I would like all files within the folder moved to
S:\Statement of Expectations\General Staff\Finance Office\old
Is this possible and if so can I do from a button or even on opening of the database.