If statement

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top