iif, then statements

[frustratedwithaccess]

Hi All,



Hoping someone can answer a question I have re iif/then statements in a query...

Basically, I have 4 fields

A, B, C, and D

I am attempting to build an expression/calculation in Field "D". Field D equals [C]-[B]. However, not all records have values in fields B and C, which leaves those records blank in field D....So wherever there is a blank record in D, I want the corresponding record from field A (where there are no blank records) to be used.

Hope someone can help
Thanks!

[pbaldy]

Try

Nz([C]-[B], [A])