Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    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
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts