Results 1 to 2 of 2
2007-12-29, 03:31 #1
- Join Date
- Jan 2001
- Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
- Thanked 0 Times in 0 Posts
Update Obsolete Items (2003 All Updates)
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
SteveDummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>
2007-12-29, 03:42 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Update Obsolete Items (2003 All Updates)
We'd need to know the design of your query. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.