Hello, I am using Access 2007 and need a macro that will create multiple tables with each name in the field "Collector" and export it to a folder with each collector's name and the current date.

So for example,

If I had Collectors: John Smith, Mary Smith, Joe Schmo, and Larry Field, it would create 4 different spreadsheets with the tables that were assigned to them.

Is this possible or will I have to make a query for each one and a macro assigned to each creating a spreadsheet for each? Keep in mind the collectors are constantly coming and going.

Let me know if you have any questions.