I am creating a pivot table in Access 97 using the wizard and it looks great. I have made some changes in Excel such as adding a new heading and making some format changes. I would prefer to do this using a report and using VBA codes instead. Can someone get me started creating a pivot table report in VBA so it will print from my switchboard. The pivot table looks great but I don't know how to get it to print like a report.

Any advice would be great!!!