Update query Help!

[Chatholo]

I have created a DB but need to update my data (Headcount) with a third party file.

As per the design of my query, I am trying to get the [Budget] table Headcount field updated with the headcount from the [august allocation] table, according to matching fields ProductID/Market/Pillar/Function.

Attached is a dummy database with my update query.


Thanks for your help!
C.

[June7]

Is this what you want:

UPDATE AugustAllocation INNER JOIN Budget ON (AugustAllocation.Function = Budget.Function) AND (AugustAllocation.Pillar = Budget.Pillar) AND (AugustAllocation.Market = Budget.Market) AND (AugustAllocation.ProductID = Budget.ProductID) SET Budget.[salary heads] = [AugustAllocation].[2014 Headcount];

[Chatholo]

Works like a dream! Thanks one more time June7!
Any chance you could look at my post named "Combo box not populating table"