Unanswered: IIF syntax with table records and Null
x: IIf(IsNull([Equipment]![x]),[Equipment Compartments]![x],[Equipment]![x])
Access reports syntax error?? I have two tables, Equip and Equip Compartments....I'm just trying to use defaults in the later if the former x value is null....thanks in advance....Al
This is because the IIf function evaluates both the truepart and the falsepart regardless of which one is actually returned. You can just use the Nz function and that will replace the IIf(IsNull(...)).