Update Obsolete Items (2003 All Updates)

Topic

New Reply

I am missing something or have a blind spot about how to do this

I have a table (TblAll Products) with all my products in it including a yes/no field to determine if a product is obsolete or not.

I have used this years list of all existing products (TblCurrentProducts) to create a query (qryObsoleteProducts) showing any non matched items ie which are in TblAllProducts but not in TblCurrentProducts and are therefore obsolete.

I tried to create an Update query from qryObsoleteProducts to set the yes/no flag in TblAllProducts to Yes but am getting an error: Operation must use an updatable query.

Where I am going wrong
TIA
Steve

Reply | Quote

Replies

We’d need to know the design of your query. Could you post a stripped down copy of your database? See post 401925 for instructions.

Reply | Quote