Display Status

P

Peter

In a select query, is it possible for me to show
A - If the field is NULL
B - If the field is NOT NULL ?

Thanks
 
I

Ian

-----Original Message-----
In a select query, is it possible for me to show
A - If the field is NULL
B - If the field is NOT NULL ?

Thanks


.
Click to expand...

Reply,

Try this

fff: IIf(IsNull([Field2]),"a","b")

Regards

Ian

ps: fff = name allociated to field
& Field2 is the field to be tested.
 
Top