Access 2007 Creating a Report from Multiple Queries

[Brett Barry: Go Get Geek!]

Hello,

I just started using Access 2007 after using Access 2003 for a long
time. I've created all my queries and they work fine. However, either
I forgot or it has changed but, how do I create a report based off of
multiple queries?

I tried using the report wizard using one query. In the Properties
sheet of the report, the record source for the report only shows one
query. But if I try and add another text box and add the control
source being the value from another query, it thinks I'm asking for a
parameter when I run the report.

And if I try to choose more than one query in the report wizard, I get
the error: "You have chosen fields from record sources which the
wizard can't connect...."

Please help, this is frustrating.

Thank you,
Brett

[CDMAPoster@fortunejames.com]

Re: Access 2007 Creating a Report from Multiple Queries

On Jun 16, 6:12 pm, "Brett Barry: Go Get Geek!"
<brettcba...@gm ail.comwrote:

Hello,
>
I just started using Access 2007 after using Access 2003 for a long
time. I've created all my queries and they work fine. However, either
I forgot or it has changed but, how do I create a report based off of
multiple queries?
>
I tried using the report wizard using one query. In the Properties
sheet of the report, the record source for the report only shows one
query. But if I try and add another text box and add the control
source being the value from another query, it thinks I'm asking for a
parameter when I run the report.
>
And if I try to choose more than one query in the report wizard, I get
the error: "You have chosen fields from record sources which the
wizard can't connect...."
>
Please help, this is frustrating.
>
Thank you,
Brett

Perhaps you can use something related to:

http://groups.google.com/group/comp.databases.ms-access/msg/bd41f6f15fc5977f

James A. Fortune
CDMAPoster@Fort uneJames.com

[Brett Barry: Go Get Geek!]

Re: Access 2007 Creating a Report from Multiple Queries

Thanks. I've actually discovered the wonderful world of subreports,
which has solved my problem. Now I have other issues...(which will be
other posts).

[CDMAPoster@fortunejames.com]

Re: Access 2007 Creating a Report from Multiple Queries

On Jun 18, 1:47 am, "Brett Barry: Go Get Geek!"
<brettcba...@gm ail.comwrote:

Thanks. I've actually discovered the wonderful world of subreports,
which has solved my problem. Now I have other issues...(which will be
other posts).

I'm glad the subreports worked for you. To me, they seem to come up
short for use in group footers :-).

James A. Fortune
CDMAPoster@Fort uneJames.com