ELiedeker
Member
- Local time
- Today, 16:31
- Joined
- Sep 22, 2020
- Messages
- 33
Hi, I have a relatively simple query I'm trying to run to update inventory with the sum of existing inventory, plus new items ordered. But I'm getting an error that my query isn't updateable, and I'm not sure what's wrong with it. In Oracle, you can update a column with the results of a calculation. Can you not do this in Access, or is there another problem with my query?
Update Supplies set InStock = (
SELECT InStock + Qty
FROM Supplies, Orders
WHERE Orders.IsComplete = True
AND Orders.InventoryUpdated = False
AND Supplies.SupplyID = Orders.SupplyID);
Thanks in advance!
Eileen
Update Supplies set InStock = (
SELECT InStock + Qty
FROM Supplies, Orders
WHERE Orders.IsComplete = True
AND Orders.InventoryUpdated = False
AND Supplies.SupplyID = Orders.SupplyID);
Thanks in advance!
Eileen