Test against a field

[brin]

How can i test against a blank field where the field is in a date format?

'ID Received' is a date field
I would like to say if 'ID Received' is blank then output 'yes'.
e.g.

ID: IIf([ID Received]="","Yes","Awaiting")

The above doesn't work produces "ERROR".

 

[dcx693]

Try:
IIf(IsNull([ID Received]),"Yes","Awaiting")

 

[brin]

That worked thanks, another question, using the same query how would i say 'is not null' as i have tried this and i get errorrs?

 

[Mile-O]

That worked thanks, another question, using the same query how would i say 'is not null' as i have tried this and i get errorrs?

IIf(IsNull([ID Received]) = False,"Yes","Awaiting")

 

[brin]

Thanks that worked a treat!!