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]

On Jun 16, 6:12*pm, "Brett Barry: Go Get Geek!"
<[e-mail]:

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....41f6f15fc5977f

James A. Fortune
CD********@FortuneJames.com

[Brett Barry: Go Get Geek!]

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]

On Jun 18, 1:47*am, "Brett Barry: Go Get Geek!"
<[e-mail]:

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
CD********@FortuneJames.com