Combining query statements

[Guest]

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;

I also want to run a similar query using a different field:

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

How do I combine the two queries into one statement so that I don't have to
run 2 separate macros?

 

[Guest]

Backup database and use this --
UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA ON
ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR SET ItemMaster.UCDEF =
AMFLIB_ITEMASA.UCDEF, ItemMaster.whslc = AMFLIB_ITEMASA.WHSLC;