Using two crosstab queries in a Report

G

Guest

I have two crosstab queries, but when I create the report, I can only choose
one of them, but I need the other crosstab query to show in the report as
well and the wizard says that it does not recognize it. How do I get this to
work?
 
G

Guest

No report of form can have more than one record source. Other than two
separate reports, it is the only way.

(I'm ugly, too, but I'm still useful:)
 
G

Guest

Thanks, but when you build the report it says that you can choose more than
one table or query, but it will not let you. Do you know what the
capabilities of Access 2007 gives?
 
D

Duane Hookom

I replied to this thread in the web-based news reader and it didn't seem to
make it here. This has happened in several other threads :-(

Can you combine the two queries into a single query? This might be done by:
1) creating a multiple value crosstab
2) creating two crosstabs and join them with a union
3) creating two crosstabs and join them with JOIN statement.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using select and crosstab queries on one report 1
Parameters with mor than one crosstab query in a report. 8
Sub report based on Crosstab query 4
crosstab query report with parameter 7
Crosstab queries and reports 1
Crosstab query fields do not show up in report 3
Wizard crosstab report failure 1
Crosstab query is no longer crosstab when I include field (in repo 1

Top