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

Report from multiple queries

P: n/a
I would like to create a summary report from the results of 11 queries
(based on 2 tables). All the queries have the same format and return
3 numbers (Count, Current Year Bal, Last Year Bal.) under different
conditions.

When I use the Report Wizard to select multiple queries to be included
in my report, I got an error msg. It says "You have chosen fields
from record sources which the wizard can't connect. You may have
chosen fields from a table and from a query based on that table. If
so, try choosing fields from only the table or only the query."

Are there other ways to do this?
Please advise.
Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I can think of possibly 2 ways.

1) Use a Union Query.
2) Use subreports, one for each query.

--
Wayne Morgan
MS Access MVP
"Gord" <gg**@och.ca> wrote in message
news:66**************************@posting.google.c om...
I would like to create a summary report from the results of 11 queries
(based on 2 tables). All the queries have the same format and return
3 numbers (Count, Current Year Bal, Last Year Bal.) under different
conditions.

When I use the Report Wizard to select multiple queries to be included
in my report, I got an error msg. It says "You have chosen fields
from record sources which the wizard can't connect. You may have
chosen fields from a table and from a query based on that table. If
so, try choosing fields from only the table or only the query."

Are there other ways to do this?
Please advise.
Thanks.

Nov 12 '05 #2

P: n/a
Wayne: Thanks for the reply.
Union query is working for me. However, the returned results were
sorted on the 1st column even thought I didn't have the "Order By".
How can I keep my query in natual order?
"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<2A******************@newssvr23.news.prodigy. com>...
I can think of possibly 2 ways.

1) Use a Union Query.
2) Use subreports, one for each query.

--
Wayne Morgan
MS Access MVP
"Gord" <gg**@och.ca> wrote in message
news:66**************************@posting.google.c om...
I would like to create a summary report from the results of 11 queries
(based on 2 tables). All the queries have the same format and return
3 numbers (Count, Current Year Bal, Last Year Bal.) under different
conditions.

When I use the Report Wizard to select multiple queries to be included
in my report, I got an error msg. It says "You have chosen fields
from record sources which the wizard can't connect. You may have
chosen fields from a table and from a query based on that table. If
so, try choosing fields from only the table or only the query."

Are there other ways to do this?
Please advise.
Thanks.

Nov 12 '05 #3

P: n/a
UNION ALL fixed the sorting problem.

Thanks.

"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<2A******************@newssvr23.news.prodigy. com>...
I can think of possibly 2 ways.

1) Use a Union Query.
2) Use subreports, one for each query.

--
Wayne Morgan
MS Access MVP
"Gord" <gg**@och.ca> wrote in message
news:66**************************@posting.google.c om...
I would like to create a summary report from the results of 11 queries
(based on 2 tables). All the queries have the same format and return
3 numbers (Count, Current Year Bal, Last Year Bal.) under different
conditions.

When I use the Report Wizard to select multiple queries to be included
in my report, I got an error msg. It says "You have chosen fields
from record sources which the wizard can't connect. You may have
chosen fields from a table and from a query based on that table. If
so, try choosing fields from only the table or only the query."

Are there other ways to do this?
Please advise.
Thanks.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.