If statement

G

Guest

Hi! I'm writing an IIf statement.
IIf([CNS_DATAENTRY_QRY]![LOC] Is Null And
[CNS_DATAENTRY_QRY]![GCS] Is Not Null,"GCS used instead",
[CNS_DATAENTRY_QRY]![LOC])

I'm hoping that by writing that if LOC is Null and GCS is
Not null that it will return the Text "GCS used instead".
However, it does not return anything, why is that?
 
L

Luiz Cláudio C. V. Rocha [MVP]

Hi,

instead of CNS_DATAENTRY_QRY]![LOC] Is Null, try
IsNull(CNS_DATAENTRY_QRY]![LOC])=-1

Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 
Top