P Peter Feb 17, 2004 #1 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
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 Feb 17, 2004 #2 -----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.
-----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.
