UPDATE query with JOIN - asking for data that should be in the joined

[cdck]

I have the following query:

UPDATE ActBud
INNER JOIN Actuals
ON (ActBud.SalesOrder = Actuals.SalesOrder)
AND (ActBud.Job = Actuals.Job)
AND (ActBud.WorkCtr = Actuals.WorkCtr)
SET ActBud.ActMat = Actuals.Mat,
ActBud.ActDollars = Actuals.Dollars,
ActBud.ActHours = Actuals.Hours,
ActBud.ActID = Actuals.ActID;

When run, it pops up a box asking me for Actuals.Mat, which I believe means that it will continue looking for each of the values that it should be pulling from Actuals. What did I do wrong?

Cheryl dc Kern

 

[PHV]

Does the Actuals table really have a field named Mat ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cdck]

Why is it that I never think of the most obvious mistake? I corrected the field name (Material, not Mat) and it runs perfectly.

Thanks.

Cheryl dc Kern