Can folders be created from access, and can files be copied from one folder to a new folder based on a search result in Access 2000? I have a table with lot numbers, and material ID fields that I would like to search, and based on the results I would like to copy files from one folder to a new one. Is it possible to search for more than one lot number at a time, and is it possible to copy files from multiple locations and paste them to one at the same time? Can this be done? What is the best way to achieve this?