[AccessD] URGENT: Report Sum of the group shifted for one record

MessageArthur is right.  This can be done with a 2-pass report.  Simply
reference the Pages property anywhere on the report.  In the first pass you
store the totals, then in the 2nd place them anywhere you need to in the
report.

 A sample of this is in the SOLUTIONS.MDB.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

  -----Original Message-----
  From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Arthur Fuller
  Sent: Thursday, February 27, 2003 9:03 AM
  To: accessd at databaseadvisors.com
  Subject: RE: [AccessD] URGENT: Report Sum of the group shifted for one
record


  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/7f56d2f0/attachment-0001.html>