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

Stuart McLachlan stuart at lexacorp.com.pg
Wed Feb 26 16:51:00 CST 2003


> 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.




-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.






More information about the AccessD mailing list