multiple report

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

Guest

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?
 
didn't think of that thanks.

is it possible use a macro to export the report to a spreadsheet to a
predefined style ?
 
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.
 
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.
 
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.
 
Back
Top