Simple query query

[Guest]

I have two similar queries that updates 2 different fields of the same
tables. How do I combine them into one statement?

I have a macro that runs a query to update a field in my Access table from a
linked table from another database:

UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA ON
ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR SET ItemMaster.UCDEF =
AMFLIB_ITEMASA.UCDEF;

UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA ON
ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR SET ItemMaster.whslc =
AMFLIB_ITEMASA.WHSLC;

 

[Marshall Barton]

I have two similar queries that updates 2 different fields of the same
tables. How do I combine them into one statement?

I have a macro that runs a query to update a field in my Access table from a
linked table from another database:

UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA ON
ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR SET ItemMaster.UCDEF =
AMFLIB_ITEMASA.UCDEF;

UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA ON
ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR SET ItemMaster.whslc =
AMFLIB_ITEMASA.WHSLC;

UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA
ON ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR
SET ItemMaster.UCDEF = AMFLIB_ITEMASA.UCDEF,
ItemMaster.whslc = AMFLIB_ITEMASA.WHSLC