Re: I am a complete novice in access help
From: Michel Walsh (vanderghast_at_VirusAreFunnierThanSpam)
Date: 06/29/04
- Next message: Alex: "left outer join problem"
- Previous message: steve carpineta: "count zero values in a query"
- In reply to: Help me please totals on page in report: "I am a complete novice in access help"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 29 Jun 2004 13:18:13 -0400
Hi,
You have to do it manually, I mean, since a PAGE of PAPER is not
DATA.... SQL can't help you.
Define a variable for the scope of the report. Initialize it to zero
each time a page start (print page header), increment it in each detail
print, push it in the appropriate control in the page footer. Three to four
lines of code, really, but at critical places, and that's all..
Hoping it may help,
Vanderghast, Access MVP
"Help me please totals on page in report" <Help me please totals on page in
report@discussions.microsoft.com> wrote in message
news:59E10C66-0BC5-488C-BC22-227FD3CBB7D3@microsoft.com...
> I am trying to calculate totals on each page of of 390 page document. I
have the report calculating the report footer correctly. I cant seem to get
it to calculate each page separately. This document has no grouping as I
dont need it grouping. Can anyone help me. Dummy in Colorado
- Next message: Alex: "left outer join problem"
- Previous message: steve carpineta: "count zero values in a query"
- In reply to: Help me please totals on page in report: "I am a complete novice in access help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
