If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Not Updateable query" error..
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! |
#2
|
|||
|
|||
"Not Updateable query" error..
Is one side of the join a primary key?
Is either BUMasterSpend or BUCatSpendTotal a totals query? Access doesn't allow you to edit records in a query that contains a totals query. You might be able to use a domain aggregate function or a subquery. -- Duane Hookom MS Access MVP -- "nycdon" wrote in message news 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! |
#3
|
|||
|
|||
"Not Updateable query" error..
Yes..BusinessUnit is primary key on BUMasterSpend..BUCatSpendTotal is a
totals query. Do you mean pull the totals query into the Update query as a subquery? Thanks, Don "Duane Hookom" wrote: Is one side of the join a primary key? Is either BUMasterSpend or BUCatSpendTotal a totals query? Access doesn't allow you to edit records in a query that contains a totals query. You might be able to use a domain aggregate function or a subquery. -- Duane Hookom MS Access MVP -- "nycdon" wrote in message news 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! |
#4
|
|||
|
|||
"Not Updateable query" error..
Using the Northwind database, this will not work after adding a TotalFreight
field to the Customers table: UPDATE Customers SET TotalFreight = (SELECT SUM(Freight) FROM Orders WHERE Orders.CustomerID = Customers.CustomerID); This did work: UPDATE Customers SET TotalFreight = DSum("Freight","Orders","CustomerID = """ & [CustomerID] & """"); -- Duane Hookom MS Access MVP -- "nycdon" wrote in message ... Yes..BusinessUnit is primary key on BUMasterSpend..BUCatSpendTotal is a totals query. Do you mean pull the totals query into the Update query as a subquery? Thanks, Don "Duane Hookom" wrote: Is one side of the join a primary key? Is either BUMasterSpend or BUCatSpendTotal a totals query? Access doesn't allow you to edit records in a query that contains a totals query. You might be able to use a domain aggregate function or a subquery. -- Duane Hookom MS Access MVP -- "nycdon" wrote in message news 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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How To Change default error messages | Rich1234 | Using Forms | 7 | March 28th, 2006 12:54 AM |
"not implemented" error adding new contacts ?? Outlook. | gone2lake2001 | Contacts | 0 | November 30th, 2005 01:35 AM |
Help! I'm getting error messages too much-can't open Resume Wizard | LizLB | General Discussion | 0 | May 3rd, 2005 01:46 AM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Error #1321 MOS 2003 Setup | Chad Harris | Setup, Installing & Configuration | 1 | June 7th, 2004 12:22 AM |