SUBTRACT MULTIPLE FIELDS
Hello I am trying to subtract multiple fields. Here is what I am trying to do: ((payment amount) - (client fee) - (override) )/2 The main problem I am having is the override field has blanks so...
Forum Discussion
You have two choices.
Set the properties of the [override] field to treat blank as zero.
or else
([payment amount] - [client fee] - Nz([override]) )/2
The Nz function will change a null numeric to a zero.
Set the properties of the [override] field to treat blank as zero.
or else
([payment amount] - [client fee] - Nz([override]) )/2
The Nz function will change a null numeric to a zero.
