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!