I am trying to query a couple of fields to base the final output. Here is what I have so far, but it is just not working...can someone please help me.
IIf(IsNull([Num_Files] And [Failed_YN]="N","0",IIf(IsNull([Num_Files] And [Failed_YN]="Y",".",[Num_Files]))))
So, I have a field called "Num_Files" in a table, and "Failed_YN" in another table and the two tables are linked by a key field. If the unit did not fail (N), and the Num_Files is null, then I want it to put a zero. If the unit did fail (Y), and the Num_Files is null, then I want it to put a period. Else, keep the value in the Num_Files field.
THANKS SO MUCH!