Multiple queries on one Report or Form in Access

Hi:
I have an access database which is creating Proposals I can send to clients
for my services. In order to generate the Proposal Report, it is necessary to
run three separate queries: One for the Services, one for the Fees, and one
for the Exclusions.

I have been successful creating a three-page report, where each page is a
separate report file, each with its related query as a record source.
However, I would like to merge these three into a single report. It is clumsy
to have each report page as a separate file.

I also have a related question about forms: Is it possible to run
simultaneous, unrelated queries on an Access form in order to build a user
home page with multiple graphs and data shown simultaneously, similar to that
shown on Microsoft Money or similar.

Thanks for any input!

There are subreports and subforms which are actually report and form objects
that are placed on "main" reports and forms. Each "sub" can have its own
record source. Usually a "sub" is related to a value on a "main" by using
the Link Master/Child properties.

--
Duane Hookom
MS Access MVP


"JamesA" wrote in message
...
Hi:
I have an access database which is creating Proposals I can send to
clients
for my services. In order to generate the Proposal Report, it is necessary
to
run three separate queries: One for the Services, one for the Fees, and
one
for the Exclusions.

I have been successful creating a three-page report, where each page is a
separate report file, each with its related query as a record source.
However, I would like to merge these three into a single report. It is
clumsy
to have each report page as a separate file.

I also have a related question about forms: Is it possible to run
simultaneous, unrelated queries on an Access form in order to build a user
home page with multiple graphs and data shown simultaneously, similar to
that
shown on Microsoft Money or similar.

Thanks for any input!

James,

I can help you on these two issues. If you need outside help, please contact
me at my email address below.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"JamesA" wrote in message
...
Hi:
I have an access database which is creating Proposals I can send to
clients
for my services. In order to generate the Proposal Report, it is necessary
to
run three separate queries: One for the Services, one for the Fees, and
one
for the Exclusions.

I have been successful creating a three-page report, where each page is a
separate report file, each with its related query as a record source.
However, I would like to merge these three into a single report. It is
clumsy
to have each report page as a separate file.

I also have a related question about forms: Is it possible to run
simultaneous, unrelated queries on an Access form in order to build a user
home page with multiple graphs and data shown simultaneously, similar to
that
shown on Microsoft Money or similar.

Thanks for any input!