<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Cross posted Access-L AccessD</FONT></DIV>
<DIV><FONT face=Arial size=2>Please help me, I'm desperate :(</FONT></DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2>In the group header is an unbound text box
Text76 </FONT></DIV>
<DIV><FONT face=Arial size=2>In the Detail section is the text
box UkSalDug=IIf([txtSaldo]>0;[txtfld1]-[txtfld2];0) with Running Sum: Over
All</FONT></DIV>
<DIV><FONT face=Arial size=2>In the code for Group Footer I want to pick this
value with: </FONT></DIV>
<DIV><FONT face=Arial size=2>Me.Text76 = Me.UkSalDug<BR>But the Me.Text76 always
get the sum of records of the previous group :(</FONT></DIV>
<DIV><FONT face=Arial size=2>So, I want:</FONT></DIV>
<DIV><FONT face=Arial size=2>John 100</FONT></DIV>
<DIV><FONT face=Arial size=2>40</FONT></DIV>
<DIV><FONT face=Arial size=2>50</FONT></DIV>
<DIV><FONT face=Arial size=2>10</FONT></DIV>
<DIV><FONT face=Arial size=2>Peter 200</FONT></DIV>
<DIV><FONT face=Arial size=2>120</FONT></DIV>
<DIV><FONT face=Arial size=2>80</FONT></DIV>
<DIV><FONT face=Arial size=2>Instead I get:</FONT></DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>John 0</FONT></DIV>
<DIV><FONT face=Arial size=2>40</FONT></DIV>
<DIV><FONT face=Arial size=2>50</FONT></DIV>
<DIV><FONT face=Arial size=2>10</FONT></DIV>
<DIV><FONT face=Arial size=2>Peter 100</FONT></DIV>
<DIV><FONT face=Arial size=2>120</FONT></DIV>
<DIV><FONT face=Arial size=2>80</FONT></DIV>
<DIV>I can't do that in the report's record source, must be done directly at the
report.</DIV>
<DIV><FONT size=2>
<P>Can anyone offer a ray of light please?</P>
<P>Many TIA,</P>
<P> Ervin</P></FONT></DIV></FONT></DIV></BODY></HTML>