sql statement in microsoft access to include IIF statement

[johnnysmith1]

Hello, I have table in microsoft access with fields- partNumber, Date, Status. ( the status field always is one of two words - on or off can I write a iif statement in sql that says IIf ([partNumber = a certain Date]), the status will automatically display off for those records with that part number. I already have alot of records entered in database. I have tried and not used to writing IIf statements in sql- also wonder can you change a field that has data in it with a iif condition statement. thank you

[Blue_Boy]

As I understand you then you want to display Status to OFF for some records which contain one certain data in field Date ?

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

modified on Saturday, June 6, 2009 5:12 PM

[johnnysmith1]

yes you are correct

[Blue_Boy]

here it is

select iif(value='2009.01.02','OFF',value) from table1

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

[johnnysmith1]

unfortunately this did not solve problem I have partNumber Date and Status I have tried Select partNumber,Date IIF(partNumber= 1011 and Date = #01/01/2006#,"OFF,ON) From table1 but still gettng errors-your sql statement is missing partNumber thank you

modified on Sunday, June 7, 2009 7:34 AM

[Blue_Boy]

johnnysmith1 wrote:

Date IIF(partNumber= 1011 and Date = #01/01/2006#,"OFF,ON)

Should be

Date , IIF(partNumber= 1011 and Date = #01/01/2006#,'OFF','ON')

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

[johnnysmith1]

thank you it works

[Blue_Boy]

You are welcome.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.