Re: "Query must use updateable query" error message
- From: "Duane Hookom" <DuaneAtNoSpanHookomDotNet>
- Date: Fri, 8 Sep 2006 21:25:16 -0500
You won't be able to write this in Access SQL syntax. Your can try:
UPDATE table1
SET CurrentPrice = DMax("Price","Table2","OrderNr=" & OrderNr);
This will be slow but should work (assuming OrderNr is numeric).
--
Duane Hookom
MS Access MVP
"Marc De Schrijver" <marc.deschryver1@xxxxxxxxxx> wrote in message
news:ezoMg.66289$3B5.1128558@xxxxxxxxxxxxxxxxxxxxxxxx
I have a complex query that serves as a basis for joining to a table whose
fields need to be updated with values from fields in the complex query.
Trying to run the update query results in the "Query must use updateable
query" message.
The basic outline of my query is as follows:
UPDATE Table1
INNER JOIN ((SELECT DISTINCT OrderNr, Max(Price) AS MaxPrice FROM Table2
GROUP BY OrderNr) AS TempTable)
ON Table1.OrderNr = TempTable.OrderNr
SET Table1.CurrentPrice = TempTable.MaxPrice
In reality the subquery to which I am inner joining is far more
complicated,
but this simplified version also results in a read-only subquery that
serves
as a basis for joining to the table that is to be updated.
How can this be done? I assume it just needs to be written differently.
Any
help would be greatly appreciated!!
-- Hans De Schryver
.
- References:
- "Query must use updateable query" error message
- From: Marc De Schrijver
- "Query must use updateable query" error message
- Prev by Date: "Query must use updateable query" error message
- Next by Date: Expression to grandfather expiration by date
- Previous by thread: "Query must use updateable query" error message
- Next by thread: Re: "Query must use updateable query" error message
- Index(es):
Relevant Pages
|
