I am maintaining an Access 2003 application and I came across the following query
UPDATE tblOpenItemsAged INNER JOIN tblOpenItemsAgeRange ON (tblOpenItemsAged.[Bank Code] = tblOpenItemsAgeRange.Bank) AND (tblOpenItemsAged.T = tblOpenItemsAgeRange.T) SET tblOpenItemsAged.[1-5 Items] = [items], tblOpenItemsAged.[1-5 $] = [$]
What does the SET statement mean if you break it down?