Blank Values

  • Thread starter Thread starter Red
  • Start date Start date
R

Red

Why when carrying out a simple subtraction in Design mode if one of the
fields IsNull the resultant value is null e.g.

ContractFee - EAC - NRExpTarg
0 - "" - 0 = ""

I need to divide by this resultant value but it produces an #error. Is there
a way round this?

Thanks in advance.
 
Hi,


Nz(ContractFee, 0) - Nz(EAC, 0) - Nz(NRExpTarg, 0 )


Will transform a NULL into a zero.

(Null is not zero, Null is something not available, unknown, so, adding 1 to
something you ignore result into something you still ignore...Null
propagates themselves, generally.)



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top