Three queries into one report

[Guest]

I have three separate queries that I need to get into one report. Each of these queries asks a question, the answer will be the same for all three. "Enter Account Number

Is there a way to make one report out of these three queries, or can I set up a Macro that allows me to answer the question once for all three queries. Each querie is very differnet from the other. The fact is that depending on how much info is in each querie/report I could be printing out mostly blank pages, so combining them on one report or page would be preferable.

 

[Tony]

Hi,

How about creating 3 sub-reports that include your 3
queries, then embed your sub-reports within 1 main
report? Will this work for you?

HTH,

Tony

-----Original Message-----
I have three separate queries that I need to get into one

report. Each of these queries asks a question, the answer
will be the same for all three. "Enter Account Number"

Is there a way to make one report out of these three

queries, or can I set up a Macro that allows me to answer
the question once for all three queries. Each querie is
very differnet from the other. The fact is that depending
on how much info is in each querie/report I could be
printing out mostly blank pages, so combining them on one
report or page would be preferable.