Ervin Brindza
medela at eunet.yu
Wed Feb 26 02:49:00 CST 2003
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/f3494c59/attachment.html>