Need to autocalculate the total field

[pratim09]

I have a form in which I have 4 fields A,B,C,D and a total field Total.
The fields takes integer values .All the fields are optional .I want the total field to autopopulate with the values i enter in these fields .I can give all values,no values,1 ,2 or 3 values. .Plz suggest

[NoellaG]

In the totals field, try the following calculation control source :

=Nz([Fieldname1])+Nz([Fieldname2])+Nz([Fieldname3])+Nz([Fieldname4])

grNG

[pratim09]

This is appending the fields in the total not adding them .plz suggest

[NoellaG]

If the numbers are concatenated, Access looks at them as textes. So you have to convert them explicit to numbers, use CInt to convert them to integers or CDbl if you have decimals. Example:

=Cint(Nz([Fieldname1]))+Cint(Nz([Fieldname2]))+Cint(Nz([Fieldname3]))+Cint(Nz([Fieldname4]))

[pratim09]

thanks a ton its working now

[NoellaG]

OK, will mark this as solved