Recent content by datta511

It worked.Thank you very much Plog.

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...