Nulls In data

[Laura1 via AccessMonster.com]

I am trying to divide two fields however some have nulls. I am appending the
results into table and I get a type conversation error the data flows it just
looks messy.

Need an iif statement I think.

Here it is:

SEV/Compbalance give desired result however there is a null in the SEV, if
SEV is null then I want to take M_O_M Value and populate the calculated field.


Any help would be great!!!

Thanks,

Laura

 

[Allen Browne]

Try something like this (one one line):
IIf([SEV] Is Not Null AND [Compbalance] <> 0,
[SEV] / [Compbalance], [M_O_M])

This will avoid the divide-by-zero error if Compbalance is zero, and will
populate with M_O_M if either field is null.