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

Mike and Doris Manning mikedorism at ntelos.net
Wed Feb 26 07:16:01 CST 2003


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.
 
Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Ervin Brindza
Sent: Wednesday, February 26, 2003 03:47 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] URGENT: Report Sum of the group shifted for one record


Cross posted Access-L AccessD
Please help me, I'm desperate :(
I want to sum the values from a text box in the Detail Section, and to put
that sum in the text box in the Group Header.
In the group header is an unbound text box Text76 
In the Detail  section is the text box
UkSalDug=IIf([txtSaldo]>0;[txtfld1]-[txtfld2];0) with Running Sum: Over All
In the code for Group Footer I want to pick this value with: 
Me.Text76 = Me.UkSalDug
But the Me.Text76 always get the sum of records of the previous group :(
So, I want:
John 100
40
50
10
Peter 200
120
80
Instead I get:

John 0
40
50
10
Peter 100
120
80
I can't do that in the report's record source, must be done directly at the
report.
Can anyone offer a ray of light please?

Many TIA,

    Ervin

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030226/ba290910/attachment-0001.html>


More information about the AccessD mailing list