[AccessD] URGENT: Report Sum of the group shifted for one record

> > Message
> >
> >   Order of Sections in a Report:  Group Header -> Detail section ->
Group Footer
> >
> >   What you are trying to do is impossible because the running sum of the
current group isn't known until AFTER the Detail section runs.
> >
> >   Learn something new today...
> >   Thanks for the info,
> >       Ervin
> >
>
> It's quite simple.
>
> In the footer, create a text field called txtSum. Set it "=Sum(myField)
> In the Header, create a text field. Set it "=txtSum"
>
> That's one of the reasons that on_format has a FormatCount parameter. In
many
> cases, the contents of the various sections are NOT calculated/formatted
in order or
> have to be calcuated/formatted again after a later part of the report is
> calculated/formatted.

Learn something new today too :)
Many thanks,
    Ervin