calculating total in a form

[Notsogood]

calculating total in a form????

Hello I am stuck on in this one as Icannot do coding. I want the "total" (which is text box) on the form to calculate the total of all the values values that I enter in the form. TI wouls like the "total" value to be displayed once I click on it, can you help me please?The "total" field is not in my table, just on my form.

 

[Mile-O]

Is the Total a Sum of numeric values or a count of them?

In the ControlSource put either:

=Count([Field])

or

=Sum([Field])


where field is changed to suit your naming.

 

[Notsogood]

Thanks for your advice.....I have multiple fields in the form with numeric values that I would put in and I want the total box to calculate that automatucally. Is there a code for that?

 

[Mile-O]

=Val([Field1]) + Val([Field2]) + Val([Field3])

 

[Notsogood]

Thanks a lot...I am trying to type in the expression u have sent but the moment I close the window the expression is getting changed......any suggestions.

 

[stormin_norm]

Make sure you put this in the control source of the field.
And field is located on the forms footer (for continuous forms)