Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Total up 3 grand totals in a report (Access 2000)

    Could someone take a look at this access database and tell me why, when i try to add up three grand totals in this rptTravel i get nothing? I mean I get the 3 totals, but its those 3 totals i want to add up...can ANYONE HELP me on this PULLLLEEASSEEE.
    I need the In-State, Out-of-State, and Local totals in the Grand total section added together for a final total somewhere in the grand total section. This is based on a Parameter query that requires a call number to be entered...You can use 0606 as an example.
    Thank you so very much.
    NMPadgett
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Star Lounger
    Join Date
    Sep 2002
    Location
    New York, New York
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Total up 3 grand totals in a report (Access 2000)

    try this & see if this is what you want:

    Add a textbox with the source set to
    =[OSGT]+[ISGT]+[LGT]
    (adds together the values from the three controls in the report footer)

    Best
    -Karl

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Total up 3 grand totals in a report (Access 2000)

    Honest to Abe, I did that already today and it DID NOT work...that is why I went in and named those controls with acronyms to make it easy to calculate....

    It worked.

    Why now after all this I don't know...but you must have put your magical touch on it...thank you so much
    NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    Star Lounger
    Join Date
    Sep 2002
    Location
    New York, New York
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Total up 3 grand totals in a report (Access 2000)

    ... it's nice to have a magic touch now, because earlier this morning I spent over 20 minutes banging my head against a problem only to discover that the problem was that I was entering a date of 9/31/2003.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •