Multiple queries on one Report or Form in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
James,

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