sum of the fields (1 Viewer)

[totolkhan]

hi ,
if i have 3 number fields , [field1] , [field2], [field3] how can i get sum of them in another field but with this if that i'll have not to enter every one of them a value .

for example
field1 = 10
field2 = (empty)
field3 = 5

field4 = [sum of 1+2+3 ] => 10+0+5 = 15

how can i do it ?!
in form and report

thanks

 

[trucktime]

Sum

Set the Control Source of Field 4 to:
=[Field1]+[Field2]+[Field3]

Set the default value for fields 1,2 & 3 to '0'

 

[ScottGem]

hi ,
if i have 3 number fields , [field1] , [field2], [field3] how can i get sum of them in another field but with this if that i'll have not to enter every one of them a value .

for example
field1 = 10
field2 = (empty)
field3 = 5

field4 = [sum of 1+2+3 ] => 10+0+5 = 15

how can i do it ?!
in form and report

thanks

If its possible for some of the fields to be empty use:

=Nz([field1],0) + Nz([field2],0) + Nz([field3],0)

Also this value shouldn't be stored since you can use that expression to calculate it wherever you need it.