Parameters and Crosstab reports

[Guest]

Two questions. I have a parameter cross tab querry to select the ranage of dates to display in the report. Ho do I use the cross tab query I created in a report.

 

[Dale Fye]

George,

If the columns will not always be the same, then this becomes an
arduous task, an example of which is listed in the "Access 2000
Developers Handbook" and provided on the accompanying disk.

If the columns will always be the same, then you can create your
crosstab query, then create a make-table query that uses the crosstab
as it's source. Now, create your report based on the table you
created. This will give you all the fields you need to work with.
Finally, change the reports record source back to the crosstab query.
I must emphasize that this will only work if the fields returned will
always be the same (for example, a report that lists sales by month
where you want to display every month, even if that month has not been
reached yet). To quarantee that these fields will always be the same,
you will probably need to use the ColumnHeadings properties in the
crosstab query.

--
HTH

Dale Fye


message Two questions. I have a parameter cross tab querry to select the
ranage of dates to display in the report. Ho do I use the cross tab
query I created in a report.

 

[Duane Hookom]

You must specify the query parameters and data types. Select
Query|Parameters and enter you exact parameters. To see some examples of
reporting crosstabs, check out
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

--
Duane Hookom
MS Access MVP

Two questions. I have a parameter cross tab querry to select the ranage

of dates to display in the report. Ho do I use the cross tab query I
created in a report.