How do you add infor from 3 boxes in form

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

Have tried to add the scores from 3 diffrent boxes in a form and it keeps
adding the whole field. have used
=[Push-up Points]+[Sit-up Points]+[Run Points]
=sum("[Push-up Points]","[Sit-up Points]","[Run Points]")

Just want 3 numbers to add up. Just for the name of that person.
 
When you say it "keeps adding the whole field", do you mean if [Push-up
Points] contains 3, [Sit-up Points] contains 2 and [Run Points] contains 1,
you end up with 321?

Try:

=CLng(Nz([Push-up Points], 0))+CLng(Nz([Sit-up Points], 0))+CLng(Nz([Run
Points], 0))
 
it adds the all the scores in the data base

Douglas J. Steele said:
When you say it "keeps adding the whole field", do you mean if [Push-up
Points] contains 3, [Sit-up Points] contains 2 and [Run Points] contains 1,
you end up with 321?

Try:

=CLng(Nz([Push-up Points], 0))+CLng(Nz([Sit-up Points], 0))+CLng(Nz([Run
Points], 0))


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Ryan said:
Have tried to add the scores from 3 diffrent boxes in a form and it keeps
adding the whole field. have used
=[Push-up Points]+[Sit-up Points]+[Run Points]
=sum("[Push-up Points]","[Sit-up Points]","[Run Points]")

Just want 3 numbers to add up. Just for the name of that person.
Click to expand...
Click to expand...
 
Back
Top