Arthur Fuller
artful at rogers.com
Thu Feb 27 08:03:00 CST 2003
Are you sure? I haven't done this for a while, so my memory may fail, but I
thought this was the point of two-pass reports - that you could do exactly
this.
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mike and Doris
Manning
Sent: February 26, 2003 8:17 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] URGENT: Report Sum of the group shifted for one
record
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/20030227/cb8f73c9/attachment-0001.html>