Recordset not Updatable

[krispi]

Hi all

I have a database of mortgage applications.

I have a query 'QryCasesToWork' which identifies applications to work based on a complex set of criteria.

Once the query has run, I need a field called 'ToDo' to update to 'yes'. Unfortunately, one of the preceding queries which goes to make up QryCasesToWork is a Union query, meaning that all the subsequent results are non-updatable.

Is there an easy way to take the application numbers returned in QryCasesToWork, and update the appropriate ToDo fields in the table?

I had a vague thought of using a Make Table query form the results of QryCasesToWork then querying that table against my main table to update the field, but this seems to me to be a cumbersome and unwieldy solution.

Does anyone have the 'correct' solution? Any help greatly appreciated.

Thanks
Chris

 

[lupins46]

You could create a query along the lines of:

Update mytable inner join (Select id from QryCasesToWork) as q1
on mytable.id = q1.id
set mytable.Todo = "Yes