Update SQL error

[Samantha]

Hi,
I'm getting a "operation must use an updateable query" error on the
following Update statement:

UPDATE tblBomMult LEFT JOIN qryWIP ON (tblBomMult.WONum = qryWIP.WONumber)
AND (tblBomMult.Component = qryWIP.PartNumber)
SET tblBomMult.QuantityRel = [qryWIP].[QtyRel];

Can anyone tell me why I can't do the above?

However, the following update sql works fine:

UPDATE tblBOM LEFT JOIN [tblBOM-XRef] ON tblBOM.Component =
[tblBOM-XRef].Component
SET tblBOM.PartXReference = [tblBOM-XRef].[PartXReference]

Any pointers to the right direction would be very much appreciatd. Thanks in
advance.

 

[Dirk Goldgar]

Hi,
I'm getting a "operation must use an updateable query" error on the
following Update statement:

UPDATE tblBomMult LEFT JOIN qryWIP ON (tblBomMult.WONum =
qryWIP.WONumber) AND (tblBomMult.Component = qryWIP.PartNumber)
SET tblBomMult.QuantityRel = [qryWIP].[QtyRel];

Can anyone tell me why I can't do the above?

However, the following update sql works fine:

UPDATE tblBOM LEFT JOIN [tblBOM-XRef] ON tblBOM.Component =
[tblBOM-XRef].Component
SET tblBOM.PartXReference = [tblBOM-XRef].[PartXReference]

Any pointers to the right direction would be very much appreciatd.
Thanks in advance.

What's qryWIP? Assuming it's a query, is it an updatable query? What's
its SQL?

 

[Samantha]

Thanks Dirk for your response.
qryWIP is a query that's grouped. What I would like to do is update table
tblBomMult with the results of query qryWIP. Can this be done?

Hi,
I'm getting a "operation must use an updateable query" error on the
following Update statement:

UPDATE tblBomMult LEFT JOIN qryWIP ON (tblBomMult.WONum =
qryWIP.WONumber) AND (tblBomMult.Component = qryWIP.PartNumber)
SET tblBomMult.QuantityRel = [qryWIP].[QtyRel];

Can anyone tell me why I can't do the above?

However, the following update sql works fine:

UPDATE tblBOM LEFT JOIN [tblBOM-XRef] ON tblBOM.Component =
[tblBOM-XRef].Component
SET tblBOM.PartXReference = [tblBOM-XRef].[PartXReference]

Any pointers to the right direction would be very much appreciatd.
Thanks in advance.

What's qryWIP? Assuming it's a query, is it an updatable query? What's
its SQL?


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)