creating a report from a cross tab query

[grantschneider]

I have a crosstab query that uses the between (two dates) function.
The query works fine but when I try to create a report out of it it
says that the row source is incorrect and will not create the
(tabular) report. Is there any way of fixing this?

 

[Allen Browne]

See:
Crosstab query techniques
at:
http://allenbrowne.com/ser-67.html

The article explains how to specify the column headings, so all columns
appear for the report even when there is no data for them.

It also explains how to declare the parameters for the report if you need to
do that.