G
Guest
I need to update a summed value from table WO to table Table1.
In table WO, I have fields: PartNumber, Quantity, and WONum. The is the
many table.
In Table1, I have fields: Component and TotalQuantity.
What I would like to do is update Table1's fields with the summed Quantity
from WO table, give that PartNumber = Component.
So far I have:
UPDATE Table1 INNER JOIN WO ON Table1_Component = WO.PartNumber SET
Table1_TotalQuantity = DSum("[Quantity]","WO","Table1.[Component]='" &
[WO].[PartNumber] & "'")
WHERE (((WO.WONum)="6k8-16246"));
It's giving me an error "Reports can't update all records in the update
query."
I've been working on this query all morning and surely would like some
pointers in the right direction! Thanks in advance!
In table WO, I have fields: PartNumber, Quantity, and WONum. The is the
many table.
In Table1, I have fields: Component and TotalQuantity.
What I would like to do is update Table1's fields with the summed Quantity
from WO table, give that PartNumber = Component.
So far I have:
UPDATE Table1 INNER JOIN WO ON Table1_Component = WO.PartNumber SET
Table1_TotalQuantity = DSum("[Quantity]","WO","Table1.[Component]='" &
[WO].[PartNumber] & "'")
WHERE (((WO.WONum)="6k8-16246"));
It's giving me an error "Reports can't update all records in the update
query."
I've been working on this query all morning and surely would like some
pointers in the right direction! Thanks in advance!