Calculated Field on Query with Null Values

[Lochwood]

I am trying to create a calculated filed in query based on the following.

If the date is null then calculated field= No
If the date is not null then calculated field =Yes

here is what i have tried to no avail:

Status: IIf(IsNull([Date]),"No") & IIf(IsNotNull([Date]),"Yes")

The error i get is "Extra ) in query expression"

 

[JHB]

What about:

Status: IIf(IsNull([Date]),"No","Yes")

 

[moke123]

your syntax is wrong

iif ( condition, value_if_true, value_if_false )

IIf(IsNull([Date]),"No","Yes")

also note that date is a reserved word

 

[Lochwood]

Knew it would be simple. thanks.