multiple report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

samuel - 13 Dec 2005 21:42 GMT

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?

Reply to this Message

Allen Browne - 14 Dec 2005 02:04 GMT

Use subreports

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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?

Reply to this Message

samuel - 14 Dec 2005 15:48 GMT

didn't think of that thanks.

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

> Use subreports
>
[quoted text clipped - 3 lines]
> > to
> > display each queries data...maybe on one report?

Reply to this Message

Allen Browne - 14 Dec 2005 16:13 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> didn't think of that thanks.
>
[quoted text clipped - 9 lines]
>> > to
>> > display each queries data...maybe on one report?

Reply to this Message

samuel - 14 Dec 2005 16:27 GMT

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.

> You can use OutputTo to export a report.
>
[quoted text clipped - 14 lines]
> >> > to
> >> > display each queries data...maybe on one report?

Reply to this Message

Allen Browne - 14 Dec 2005 16:29 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>i ran each query individually, copied the results, and put them into a
> spreadsheet.
[quoted text clipped - 21 lines]
>> >> > to
>> >> > display each queries data...maybe on one report?

Reply to this Message