Combining query statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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;
 
Back
Top