Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Thanked 0 Times in 0 Posts

    Update query (Acces 2000)

    I have an updatable query based on 2 queries.qryinput and qry output. I want to update a field in the table products with this result. Since the query is non updatable ,how should i proceed, can i use the dlookup function? How should it look like? My query is the following
    SELECT qryInput.ProductID, qryInput.Sum1, qryOutput.Sum2, [Sum1]-[Sum2] AS Rest
    FROM (qryInput INNER JOIN qryOutput ON qryInput.ProductID = qryOutput.ProductID) INNER JOIN products ON qryInput.ProductID = products.Productid;

    I want to update the field products.items4( table products,field items4) with the field Rest from the query.
    Can you help me ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Update query (Acces 2000)

    See <post:=683,951>post 683,951</post:> - the solution should be similar.

Posting Permissions

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