USING DYNAMIC COLUMNS TO CREATE A REPORT OFF A CROSSTAB QUERY
One of the more powerful report tasks is to create a report that can dynamically change, depending on the circumstances at the time the report is run. An example of this—and one that will be used for the rest of this discussion—is a production report that tracks the sales for customers over a set period of months.
This report, DynamicColumnsExample, is based off a crosstab query named qxtbDynamicColumnExample. The report is opened in Print Preview from the form named DynamicColumnsExamples, which is built the same way as the other sample forms in this chapter.
Looking at the Query by Form Used for the Report
The DynamicColumnsExample form has three controls on it—a text box named ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
