By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Access 2007 Creating a Report from Multiple Queries

P: n/a
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
Jun 27 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Jun 16, 6:12*pm, "Brett Barry: Go Get Geek!"
<brettcba...@gmail.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....41f6f15fc5977f

James A. Fortune
CD********@FortuneJames.com
Jun 27 '08 #2

P: n/a
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).

Jun 27 '08 #3

P: n/a
On Jun 18, 1:47*am, "Brett Barry: Go Get Geek!"
<brettcba...@gmail.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
CD********@FortuneJames.com
Jun 27 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.