Using two crosstab queries in a Report

T

Tina

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?
 
K

Klatuu

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:)
 
T

Tina

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Using select and crosstab queries on one report 1
Office 10 Crosstab query with Parameters 0
Crosstab query is no longer crosstab when I include field (in repo 1
Crosstab queries and reports 1
Crosstab query with changing column headings 5
Sub report based on Crosstab query 4
Report Error for certain Crosstab Query 2

Top