batch977
06-26-2003, 01:47 PM
I am looking for a query statement that will look at two fields and return the value in "field A" if it is not null, and the value in "field B" if "field A" is null.
Thank you.
Thank you.
|
View Full Version : return one of two values batch977 06-26-2003, 01:47 PM I am looking for a query statement that will look at two fields and return the value in "field A" if it is not null, and the value in "field B" if "field A" is null. Thank you. Fuga 06-26-2003, 01:59 PM Check out the IIF() function. Fuga. FoFa 06-27-2003, 05:58 AM IIF(ISNULL([FieldA]),[FieldB],[FieldA]) |