Crosstabbed queries into reports

[Emma]

Hi again!

I am trying to create a report that runs from a crosstab query, though it has just occurred to me that at the moment, there are less columns in my report than there potentially could be. The crosstab query the table is based on uses a lookup field to create the columns and at the moment not all the options in the lookup field have been used. How can I add the new columns to the report as the crosstab query changes?

Many thanks for any ideas!

Emma

 

[Pat Hartman]

You can use the columns property of the crosstab to specify the values you want included. This will fix the column count to what ever is specified. For example if you entered Jan, Feb, and Mar, only those three months would appear in the crosstab. No other months would ever show and those three months would always show even when there wasn't any data.

 

[Emma]

Thankyou Pat! That is really so simple and yet has solved a really annoying problem!

Many thanks!
Emma