Access macros & printing

[debshoe]

I have a very long macro consisting of several queries that all output to
print. Some of those queries only return a couple of lines of text. It is
wasteful of paper to print each query on separate page. How can the macro
run the query (to get results I want) and print multiple queries on 1 page?

 

[Steve Schapel]

Debshoe,

Only thing I can think of is to make a report based on each of the
queries, and then place them one after the other as subreports on
another unbound main report. That way, you just print the main report,
and the subreports will grow to accommodate the amount of data returned
from each of the queries.