multiple report

S

samuel

i have multiple queries that are not related.

instead of creating multiple reports, one for each query, is there a way to
display each queries data...maybe on one report?
 
S

samuel

didn't think of that thanks.

is it possible use a macro to export the report to a spreadsheet to a
predefined style ?
 
A

Allen Browne

You can use OutputTo to export a report.

Not sure what you mean by the predfined style. If you export a snapshot you
can keep any graphical elements.
 
S

samuel

i ran each query individually, copied the results, and put them into a
spreadsheet.

i'd like to automate the process, by way of macro, to export the report to
the same style i have my spreadsheet.
 
A

Allen Browne

If you are exporting queries, you could use TransferSpreadsheet in a macro.

Perhaps you already tried the OutputTo action in your macro to export the
report.
 
Top