Event Tab to update a null field

[goslincm]

Good morning, not sure if I'm in the correct area for this question.

I have a field [Amount] that is one of two fields used to computer a total field. However, IF [Amount] is left blank by a user, I want it to switch that null to a zero so my total field will still compute. Is that possible?

At this point, the way the database is designed, I cannot make [amount] a required field.

 

[PHV]

Have a look at the Nz function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886