How do you add infor from 3 boxes in form

[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.

 

[Douglas J. Steele]

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))

 

[Ryan]

it adds the all the scores in the data base

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)

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.