MSAC2K: Reporting Sum of Items Printed on Page

  • Thread starter Thread starter David Dubroff of Mr. PC
  • Start date Start date
D

David Dubroff of Mr. PC

Microsoft Access 2000:

I have several reports that pertain to a bunch of car parts that are being
sold as one entire lot.

One report shows most of the car parts, and several smaller reports show
some additional car parts based on specific criteria relating to the part
number.

How would I print a dollar sum on each page for only those parts that appear
on that particular page (page total)?

Also, would I be able to print a running sum value from page to page, of
just the page totals?

Please advise...

Dave
 
Hi David,

See the following articles:
ACC2000: How to Create Page Totals on a Report
http://support.microsoft.com/default.aspx?scid=kb;en-us;216311

ACC2000: How to Sum a Calculation in a Report
http://support.microsoft.com/default.aspx?scid=kb;en-us;208850

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"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."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Reply-To: "David Dubroff of Mr. PC" <[email protected]>
| From: "David Dubroff of Mr. PC" <[email protected]>
| Subject: MSAC2K: Reporting Sum of Items Printed on Page
| Date: Sat, 20 Mar 2004 21:55:27 -0500
| Lines: 21
| Organization: Mr. PC
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <#[email protected]>
| Newsgroups: microsoft.public.access.reports
| NNTP-Posting-Host: pcp01414057pcs.potshe01.pa.comcast.net 68.81.51.100
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.reports:134003
| X-Tomcat-NG: microsoft.public.access.reports
|
| Microsoft Access 2000:
|
| I have several reports that pertain to a bunch of car parts that are being
| sold as one entire lot.
|
| One report shows most of the car parts, and several smaller reports show
| some additional car parts based on specific criteria relating to the part
| number.
|
| How would I print a dollar sum on each page for only those parts that
appear
| on that particular page (page total)?
|
| Also, would I be able to print a running sum value from page to page, of
| just the page totals?
|
| Please advise...
|
| Dave
|
|
|
|
 
Back
Top