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 are the queries I want to combine:
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"));
UPDATE [tbl_A] INNER JOIN tbl_B ON [tbl_A].Email = tbl_B.Email
SET tbl_B.[PACP Status] = [tbl_A]![Item Status]
WHERE ((([tbl_A].[Item Name])="Course 2"));
UPDATE [tbl_A] INNER JOIN tbl_B ON [tbl_A].Email = tbl_B.Email
SET tbl_B.[LSR Status] = [tbl_A]![Item Status]
WHERE ((([tbl_A].[Item Name])="Course 3"));
Please let me know if I can provide additional information.
Thank you.
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 are the queries I want to combine:
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"));
UPDATE [tbl_A] INNER JOIN tbl_B ON [tbl_A].Email = tbl_B.Email
SET tbl_B.[PACP Status] = [tbl_A]![Item Status]
WHERE ((([tbl_A].[Item Name])="Course 2"));
UPDATE [tbl_A] INNER JOIN tbl_B ON [tbl_A].Email = tbl_B.Email
SET tbl_B.[LSR Status] = [tbl_A]![Item Status]
WHERE ((([tbl_A].[Item Name])="Course 3"));
Please let me know if I can provide additional information.
Thank you.