Form Sum

[jadefury]

I am looking to do a single form sum. I have already created my option groups and assigned a value to each check box. I have an unbound text box and was trying to use this formula

=sum[q1]+[q2]+[q3]

The answer I am getting is from all forms and it is not totaling the numbers it is just giving me a string of numbers for example: 334

I am looking for it to total just on a single form with an answer of: 10

Thanks for the Help!

 

[Rich]

=Sum(Iif([MyCheckbox1)1,0) + Sum(Iif([MyCheckbox2)1,0) etc.etc

 

[jadefury]

is the 1,0 in the above formula trying to assign a value to the checkbox for example if checked =1 or not checked = 0. The formula does not seem to work as I have four check boxes in an option group. The values of the check boxes are again already assigned from 0-3.

 

[Subcancel]

Did you just forget the ( ) ? as in =Sum([q1]+[q2]+[q3])

 

[jadefury]

still all that does is is group the option groups together so for example in option group 1 the third check box is checked and in option group two the 2nd check box is checked I get:21

It isn't adding the values from each option group already assigned it is just listing them in a row.

Thanks!

 

[Subcancel]

Have you try doing the calculations with on click event? Like make a button and do some code behind.

ex.

Private Sub Command_Click()

Me.Textbox = Me.OptionGroup1.Value + Me.OptionGroup2.Value

End Sub

Just shooting Ideas out there...

 

[boblarson]

How about simply:

=Sum(Val(Nz([q1],0))+Val(Nz([q2],0))+Val(Nz([q3],0)))

 

[jadefury]

Thanks Boblarson it worked