Group events

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sam Hobbs (samuel_at_social.rr.com_change_social_to_socal)
Date: 09/15/04 

Date: Tue, 14 Sep 2004 20:58:20 -0700

I need to summarize a field for a group footer. This report, however, does
not use detail lines; it consists entirely of three groups. I assume that
the absence of a detail line is causing the usual group footer total
mechanism to not work. However just to be sure, I will explain what I did
that did not work.

Just to be sure I amusing the correct terminology, the most infrequent group
is level 0. The next is level 1 and the most frequent level, that appears on
the report to be thje detail level, is level 2.

In level 1, we have the calculation "cost * quantity". We need to summarize
that value for the level 0. I add a textbox to the level 0 footer and set
the control source to "cost * quantity". It does not summarize the values,
whether or not I set the Running Sum to "Over Group"

I assume the problem is a lack of a detail line. So I have tried to use the
"On Print" event to calulate the total. In the "On Print" event for the
level 0 header, I set the text box in the level 0 footer to zero. In the
level 1 header, I acummulate the "cost * quantity". That is, I add the level
1 value to the level 0 footer text box. This does not work either. No matter
what I try, I always get the value from ither the first or the last level 1
(group) line.

This is something that should be easy, but I don't know what Access is doing
so I don't understand how I should make it work.

Relevant Pages

  • Re: subreport/report total question
    ... In the subreport, move your DayTotal text box into the Report Footer ... Page Header ... job totals always match the Work_Date totals because it gives me a job ...
    (microsoft.public.access.reports)
  • Re: Can Shrink and Grow = yes
    ... Here's what my report is like: ... Page Header ... Footer section, with closing signatures for letter ... KeepTogether property set, then the group will be split ...
    (microsoft.public.access.reports)
  • Re: Process not working on laptop
    ... I just figured out that Access10 is simply processing the ... report differently than Access97. ... Page Header section to the Page Footer section ends up coming ...
    (comp.databases.ms-access)
  • Re: Detail sections Height property does not alter when shrinks / gro
    ... The height of Page Header, Page Footer, top margin and bottom margin ... X 11 paper and printing in portrait, the sum of the heights of Page Header, ... Get the height of the detail section you set in report design view. ... I wish to draw boxes in this section and need to establish the Detail ...
    (microsoft.public.access.reports)
  • Re: Process not working on laptop
    ... the code below enabled the Access10 computers to print the reports ... with the correct data in the Page Footer. ... report differently than Access97. ... Page Header section to the Page Footer section ends up coming ...
    (comp.databases.ms-access)