F. Scott Barker's Microsoft® Access 2000 Power Programming

Chapter 11. CREATING POWERFUL REPORTS

IN THIS CHAPTER

• USING THE SAME REPORT FOR SUMMARY, DETAIL, AND SUMMARY/DETAIL REPORTS

• USING QUERY BY FORM TO CREATE DYNAMIC GROUPINGS FOR THE SAME REPORT

• THE ELUSIVE FEATURE: CREATING SNAKING REPORTS

• USING DYNAMIC COLUMNS TO CREATE A REPORT OFF A CROSSTAB QUERY

• CHOOSING MULTIPLE TOPICS TO PRINT BY USING THE MULTISELECT LIST BOX

• CREATING A WIZARD-LIKE INTERFACE FOR SELECTING GROUP-BY ITEMS

• FORMATTING REPORTS DYNAMICALLY

For the most part, day-to-day reports are easy to use and don't need any code at all. Even creating reports by using subforms isn't that tough and can be figured out pretty quickly. Some things, however, might not be quite as straightforward and do need a bit of code:

• Using the same report for your ...