I'm trying to return the value of one column based on the condition of other columns. If Value2 = 0, then return Value1. But, if Value1 = 0, then return Value3. Can you please review my IIf statement and tell what I need to add for completion?
For example, in the attached database (Record 1), should return 900 since Value1 and Value2 = 0, but there is an amount in Value3.