Richard, often times my manager wants her reports to read like a dashboard and will request more than one report to be listed on the same page. I thought I could just grab fields from the different queries but that was not the case. I just purchased your entire Access series and it is the best I have seen so far. Thanks for the detail. I have spent twice the cost your Access purchase price in books, dvd, website online training etc and still did not understand Access. With just your volumes 101 and 102 I have done more than I have with 7 different books on Access. All the others tell you how to get things done with no explaining or reasoning. For all of left brain engineer type folks your course removes the stress. By the time I get to the 300 level man I will be knocking it out of the park thanks!

---

Reply from Richard Rost:

Thank you so much for the compliments!

Yes, in the case of your manager, I would recommend just printing multiple reports. You CAN do that automatically with a single button press if you create a form with command buttons on it. This will require a little VBA programming, and we will get to this in the 300-level classes. Essentially if you want to print multiple reports you would just issue 2 or more DoCmd.OpenReport statements in the same button.

Ask me this again when you get to AC301. :)