<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=490245013-26022003><FONT color=#0000ff
size=2>Ervin,</FONT></SPAN></DIV>
<DIV><SPAN class=490245013-26022003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=490245013-26022003><FONT color=#0000ff size=2>Write an
aggregate query that sums the field in question and use that as the
datasource for the header field.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#000000>(SELECT * FROM users WHERE clue > 0)</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Mike and Doris Manning
[mailto:mikedorism@ntelos.net] <BR><B>Sent:</B> Wednesday 2003 Feb 26
07:17<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] URGENT: Report Sum of the group shifted for one
record<BR><BR></FONT></DIV>
<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>