Search results

Hi, thank you for your response, however it didn't quite work. I think it's because I'm trying to make the update to different fields: UPDATE [tbl_A] INNER JOIN tbl_B ON [tbl_A].Email = tbl_B.Email SET tbl_B.[PBC Status] = [tbl_A]![Item Status] WHERE ((([tbl_A].[Item Name])="Course 1"))...

Hi, I'm a beginner MSAccess, SQL user. I'm currently working in MS ACCESS 2007 creating multiple update queries to update different fields. Can you please advise how can I combine these queries into 1? That is, i want to update all the fields at once rather than one query at the time. These...