Ms Acces combine two quries

[datta511]

Hi Friends,

How can I create single query from 2 in MS Access 2007? (SQLView)

Query 1

UPDATE ETAM_PeopleSoft_Data
SET USER_TYPE= 'Inactive'
Where USER_TYPE= 'T'

Query 2

UPDATE ETAM_PeopleSoft_Data
SET USER_TYPE= 'Active'
Where USER_TYPE<> 'T'

I tried below but it didn`t worked...

UPDATE ETAM_PeopleSoft_Data SET USER_TYPE= Case WHEN USER_TYPE='T' THEN 'Inactive'
ELSE 'Active'
END AS USER_TYPE


Thank you,
Datta

 

[plog]

UPDATE ETAM_People_Soft_Data
SET USER_TYPE = IIf([USER_TYPE]='T', "Inactive", "Active")

Be sure to backup ITEM_People_Soft_Data before trying any action query.

 

[pbaldy]

FYI I moved your thread to a more appropriate forum.

 

[datta511]

It worked.Thank you very much Plog.