I cant seem to get this to work, i have three fields and a total field in a form that will not total if one of the three have a null value.
field1+field2+field3 = field4, all are number data types, all have 0 default values.
Problem: if user needs to change or move a value from say field1 to field2, fields1 value is deleted and then entered in field2. The problem is that now field1 has a null value and then field4 which is the total does not calulate.
I tried using the NZ funtion on the after update event and no luck. Tried a couple other things and still no go. I am sure I am missing something simple, any help is appreciated.
field1+field2+field3 = field4, all are number data types, all have 0 default values.
Problem: if user needs to change or move a value from say field1 to field2, fields1 value is deleted and then entered in field2. The problem is that now field1 has a null value and then field4 which is the total does not calulate.
I tried using the NZ funtion on the after update event and no luck. Tried a couple other things and still no go. I am sure I am missing something simple, any help is appreciated.