multi-page, multi-query reports

  • Thread starter Thread starter jbm22
  • Start date Start date
J

jbm22

Hi;
I am trying to do a report for an insect control project
where the first page summarizes the subunit info and the
second page will give detailed info for each site in the
subunit. Should I use a macro or a subreport? I've tried
a subreport without much success.
TIA
John McGuire
 
John wrote:

--------------------
| Content-Class: urn:content-classes:message
| From: "jbm22" <[email protected]>
| Sender: "jbm22" <[email protected]>
| Subject: multi-page, multi-query reports
| Date: Wed, 14 Jan 2004 09:29:08 -0800
| Lines: 8
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcPaw+pfb+eFI/5uQ7a9Y7eX/qatDg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.reports:127852
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.reports
|
| Hi;
| I am trying to do a report for an insect control project
| where the first page summarizes the subunit info and the
| second page will give detailed info for each site in the
| subunit. Should I use a macro or a subreport? I've tried
| a subreport without much success.
| TIA
| John McGuire
|

Have you considered using Grouping in your Report? For instance in your
Group header you would have the summary information of for each subunit and
the Detail section would have the detail for each site. And if you are
looking for the detail information to appear on the 2nd page use a Page
Break in the Group header.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
 
Back
Top