Two crosstab queries in the same report!

[Anna]

Hi!

Does anyone know if it is possible to use two or more different crosstab queries in the same report at the same time? Is there a simple way to do this? The report must be able to show the results for both crosstabs at the same time.

Thankful for all help!
/Anna

 

[jboyle]

Anna,
Create a report for crosstab1 then create another report for crosstab2.

Now create a blank report and use the subform/subreport option on the toolbox menu to stick in the crosstab1 report and repeat this procedure for the crosstab2 report.

This will give you a report with both reports contained within it.

Hope this helps you - John Boyle

 

[Pat Hartman]

You can create a third query that joins the two crosstab queries and use the third query as the recordsource for the report.

 

[Anna]

Thanks for all help!

It worked out just fine.

/Anna