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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

no results returned in query 1
Aggregate Function Error 0
Multiple iif challenge 2
Criteria from Form 3
Insert Row also adds formulas and moves cursor 2
Gulf Coastal Software - Freeware 3
iif is null statement with qualifiers 4
IIf statement 3

Back
Top