Create a report with variable columns from month to month

  • Thread starter Thread starter Bob & Gus
  • Start date Start date
B

Bob & Gus

We want to create a report that references a crosstab
query and then automatically adjusts itself to the number
of columns produced.

The query information is constantly changing.

Example: One day the query may produce five columns; next
week the same query may increase to 30 columns (a maximum).

Presently, we have to adjust the report to fit the results
of each query. Ideally, the report would adjust itself to
the results of the query. Suggestions, please and thanks.
 
Just a thought (adapted from help), can't you create
ColumnHeadings in the property box for the 30 columns,
type the column headings you want to appear in the report,
separating each one with a semicolon. If a column heading
contains spaces, enclose it in double (" ") quotation
marks. For instance, in a query showing sales by quarter,
you would type: "Qtr 1";"Qtr 2";"Qtr 3";"Qtr 4"

That way the report is always adjusted for the maximum
amount of columns...
 
Back
Top