Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sum Function (2000)

    Hey, I am working on a sum function when using a report through the button on the form and it does not work?? I know this is simple but I am drawing a blank to why I would be wrong, i pasted a zip file with the mdb in it.
    Thanks,
    Jordan
    Attached Files Attached Files

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

    Re: Sum Function (2000)

    1. You should refer to the sum of the field Total Cost, not of the control Text57 in the Control Source of Text0: =Sum([Total Cost])

    2. The text box displaying the sum should be in the report footer, not in the page footer. If you prefer to display the sum in the page footer, make the text box with the sum (Text0) in the report footer invisible, and put another text box in the page footer, with Control Source: =[Text0]

  3. #3
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum Function (2000)

    thanks Hans!

Posting Permissions

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