Add expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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. ...
 
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]
 
Back
Top