O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required