Using two crosstab queries in a Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tina - 28 Nov 2006 16:09 GMT

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?

Signature

Tina

Reply to this Message

Klatuu - 28 Nov 2006 16:37 GMT

Sub Report?

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

Reply to this Message

Tina - 28 Nov 2006 16:52 GMT

is there any other way besides a sub report, it really looks ugly.

Signature

Tina

> Sub Report?
>
> > 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?

Reply to this Message

Klatuu - 28 Nov 2006 17:11 GMT

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

> is there any other way besides a sub report, it really looks ugly.
>
[quoted text clipped - 4 lines]
> > > well and the wizard says that it does not recognize it. How do I get this to
> > > work?

Reply to this Message

Tina - 28 Nov 2006 18:54 GMT

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?

Signature

Tina

> No report of form can have more than one record source. Other than two
> separate reports, it is the only way.
[quoted text clipped - 9 lines]
> > > > well and the wizard says that it does not recognize it. How do I get this to
> > > > work?

Reply to this Message

Duane Hookom - 30 Nov 2006 03:01 GMT

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.

Signature

Duane Hookom
MS Access MVP

> Thanks, but when you build the report it says that you can choose more
> than
[quoted text clipped - 17 lines]
>> > > > get this to
>> > > > work?

Reply to this Message