G
Guest
Trying to update a table based on another. Getting messsage "Operation must
use an Updateable query. Anyone see anything wrong with this?
Business unit is on both tables..trying to build/update Master table with
2nd table.
UPDATE BUMasterSpend INNER JOIN BUCatSpendTotal ON
BUMasterSpend.BusinessUnit = BUCatSpendTotal.BusinessUnit SET
BUMasterSpend.HardWareSpend = [BUCatSpendTotal]![SumOfSpend]
WHERE [BUCatSpendTotal]![Category]="Hardware";
Thanks!
use an Updateable query. Anyone see anything wrong with this?
Business unit is on both tables..trying to build/update Master table with
2nd table.
UPDATE BUMasterSpend INNER JOIN BUCatSpendTotal ON
BUMasterSpend.BusinessUnit = BUCatSpendTotal.BusinessUnit SET
BUMasterSpend.HardWareSpend = [BUCatSpendTotal]![SumOfSpend]
WHERE [BUCatSpendTotal]![Category]="Hardware";
Thanks!