Query not recognizing blank fields

[Rodrigo Borges]

I have a table with a date field that have some registries with #Num!

When I create a simple query all registries listed in the table as #Num! are
listed as "" (blank) on my query.

Now I need to to check if this field is "" then bla bla... I'm using the
following:

Status: IIf([Latest Report]="";"ERROR";"OK")

The result is always the ELSE option. So, here is OK.... What I'm doing
wrongly?

Rodrigo Borges

 

[Carl Rapson]

I have a table with a date field that have some registries with #Num!

When I create a simple query all registries listed in the table as #Num!
are listed as "" (blank) on my query.

Now I need to to check if this field is "" then bla bla... I'm using the
following:

Status: IIf([Latest Report]="";"ERROR";"OK")

The result is always the ELSE option. So, here is OK.... What I'm doing
wrongly?

Rodrigo Borges

Try IsNull instead:

IIf(IsNull([Latest Report]),"ERROR","OK")

Carl Rapson