<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=683211213-26022003><FONT face=Arial color=#0000ff size=2><SPAN
class=683211213-26022003><FONT face=Arial color=#0000ff size=2>Order
of Sections in a Report: Group Header -> Detail section ->
Group Footer</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=683211213-26022003><FONT face=Arial color=#0000ff size=2><SPAN
class=683211213-26022003></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=683211213-26022003><FONT face=Arial color=#0000ff size=2><SPAN
class=683211213-26022003></SPAN>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.</FONT></SPAN></DIV>
<DIV><SPAN class=683211213-26022003></SPAN><SPAN
class=683211213-26022003></SPAN><SPAN class=683211213-26022003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=683211213-26022003>
<DIV align=left><FONT face=Arial size=2>Doris Manning</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Database Administrator</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Hargrove Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial color=#0000ff
size=2><U>www.hargroveinc.com</U></FONT></DIV></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>Ervin Brindza<BR><B>Sent:</B> Wednesday, February 26, 2003
03:47 AM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] URGENT: Report Sum of the group shifted for one
record<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>