Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    1

    Unanswered: Sum of more than two fields in a form

    I have a form with several fields I want to calculate to another field (Cash). I can use this =Sum([100])+([50]), and it works but for more than two fields it will not calculate right. I also have a fields for 20,10,5,2,1 and when I add them on to the =Sum calculation, it just does not work. I want all those to claculate into the cash field. I know I should have paid more attention in Algebra.

    Dave

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    =Sum([100])+([50])
    This will sum the value 100 (=100) and then add 50.
    You need to look into how the Sum() function works, I think you'll see what's wrong fairly quick, but if not, feel free to come back and ask!
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    =Sum([100]+[50]+[20]+[10]+[5])

    If you are using this as a cash counting operation be aware of HOW you're entering the values. it will require the cash value NOT the count of how many 50's there are ie 10 - 50s' will be 500 and not 10 unless you are multiplying by the cash type

    gareth

Posting Permissions

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