M
mslee65
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;
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;