Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculation on Report (Access 2002)

    I have an accounts receivable DB on the report for each customer Balance =([Total Withdrawals]-[Total Discounts])-[Total Deposits] . I'm trying to calculate a grand total and when I do Grand Total = Sum([Balance]) I'm receiving a enter box for "Balance". What am I leaving out? Thanks a bunch! <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculation on Report (Access 2002)

    Yep, that's correct. If you want to perform a calculation in the report footer in a report, you have to perform it on the fields from the record source, not on a calculated control in the detail section.

    Alternatively, you could have placed a second text box txtRunSum with Control Source

    =([Total Withdrawals]-[Total Discounts])-[Total Deposits]

    in the detail section, and set its Running Sum property to Over All and its Visible property to No. Put a text box in the report footer with Control Source

    =[txtRunSum]

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculation on Report (Access 2002)

    I guess I just needed to talk it out.. It's =Sum(([WithdrawalAmount]-[DiscAmount])-[DepositAmount]) <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> .. Thanks for allowing me to Talk OUT LOUD!

Posting Permissions

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