Report from multiple queries

[Gord]

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.

[Wayne Morgan]

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.

[Gord]

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.

[Gord]

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.