Add expression

M

Martin

How do I add a seperate column in my query with the following criteria; I
currently have a column called "ResponseTime", I would like to create another
column that says "Yes" if there is data in my "ResponseTime" column and "No"
if there is no data. I am unsure of how to accomplish this.
 
M

MGFoster

Martin said:
How do I add a seperate column in my query with the following criteria; I
currently have a column called "ResponseTime", I would like to create another
column that says "Yes" if there is data in my "ResponseTime" column and "No"
if there is no data. I am unsure of how to accomplish this.
Click to expand...

SELECT ResponseTime,

IIf(ResponseTime IS NOT NULL,"Yes", "No") As ObviousColumn

FROM ... etc. ...
 
J

John Vinson

How do I add a seperate column in my query with the following criteria; I
currently have a column called "ResponseTime", I would like to create another
column that says "Yes" if there is data in my "ResponseTime" column and "No"
if there is no data. I am unsure of how to accomplish this.
Click to expand...

In a vacant Field cell type

Responded: IIF(IsNull([ResponseTime], "No", "Yes")

John W. Vinson[MVP]
 
Top