I'm not sure what you mean post the SQL behind the query?
The data is populate by manager, no time periods. Only one query exists and they need to dynamically created (split by manager).

I am trying to understand how to write VB code in Access 2010 to automatically populate the data into multiple excel spreadsheets. The data in the query encompasses all the data (by manager), but I need to separate the files by manager. The files need to be automatically exported to excel with the name of each manager which should give me 32 exported files. I'm new to VBA and have read posts for the last 2 days and can't figure it out.
Thanks...