update query problem (1 Viewer)

Hi,

I have an update query to update some data in a table, however I am using another query to filter out the items to update, I have brought the query into the update query and linked the field that will filter the records but because the filtering query uses a sum it is non-updateable which means the update query is non-updateable!
Is there a way to get around this? Other than having to set up a table, import the id numbers from the sum query then using that table in the update query.
I wondered if there was a setting in the preferences or something you can write in the SQL to make it ignore the fact that a non-updateable query is being used to filter the table for updating? I am only using it to filter the ID numbers.

Resolved

I have sorted out the problem now, don't know if it was the most conventional solution but I found that if I got rid of all non essential fields in the non-updateable query just leaving 2 then the update query worked.
I have no idea why that works but it does so I'm not going to worry about it!