I have a spreadsheet contaning about 50K sales records, grouped by VP, Sales manager, and Sales rep. I would like to create a report process in MS access that will allow me to
group the output by VP
place the output for each Sales manager on a separate tab/subreport (think excel workbook tabs)
email the report to each VP for his /her respective sales manager team
I know how to write the queries to break out the sales teams; what is the best way to create the report--export excel build report/subreports?