Unanswered: Update Query--Vary what field is updated
I want the end user to be able to vary what week is updated, either by a vba or like a parameter query. My end users only have the run time version of access and design view is not an option. This one has me stumped and i have not found a solution. wksales. is what needs to be varied. it will always be from the table wksales but i need to vary what week they are updating to, 1 through 52.
UPDATE WklySalesUpdate LEFT JOIN wksales ON (WklySalesUpdate.yr = wksales.yr) AND (WklySalesUpdate.Item = wksales.item) AND (WklySalesUpdate.Whse = wksales.whse) SET wksales. = [WklySalesUpdate].[qty];