Update query in MS Access 2007

[Jeevie]

Hello All

I am trying to update a Field 1 in Table A with the Sum of values of Field 2 in Table B. However I am getting the error "operation must use an updateable query".

Can anyone help with a sample query.

Thanks in advance

[jonh]

You would think a simple update should be easy enough, but it's one of those things that Access is pretty useless at.

Insert the calculated values into a temporary table and then update the table from there.