Recent content by polettima

The query is now ok, only a wrong space error. Thanks

No problem for the parenthesis. The query returns me some cast problem and doesn't update the table. Now I'll try to solve.

@ PHV The query runs, now I'll check the output (many lines to check), but I thank you so much.

@ PHV I've already tryed that kind of query , but access returns me the error message (translated from italian): "for the operation it's necessary an updatable query " (i work locally and i have all the permissions on the .mbd file)

Both of the query (the update and the select) returns the same error: (i translate from italian): 'Impossible to execute a query that doesn't have "fatherId" as part of an aggregation' Usually you resolve this problem using HAVING at the end of the query, in this case HAVING FatherID , but it...

Thank you, but i got an error message if i try to execute your query.

Hello I need help with an update query I got 2 ms Access tables. -Table_A Fields: ID - FatherID - Price - Quantity -Table_B Fields: ID - Price I have to update Table_B.Price With the sum of Table_A.Price GROUP BY Table_A.FatherID , With the condition that Table_A.FatherID = Table_B.ID...