I have a form with several fields I want to calculate to another field (Cash). I can use this =Sum()+(), 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.
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