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

    Update query (Access 2000)

    I need help in building an updater query.I have 2 tables products and offset. I want to update th field DDU with the following values depending on the size of the product :
    DDU = [products].[exworks]*2+[offset].[freight]+[offset].[oiltax]+[offset].[Packtax]
    With the above values I have built the query qryUpdateWithComponents.However my update query does not update the last value, namely packtax. This can be seen with the example from the query a1, taken for the product 487.The ddu in this example is 5.35, but this is not right, because the packtax of 0.071 is not included.How could I solve this problem ?
    Attached Files Attached Files

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

    Re: Update query (Access 2000)

    You should join the tables on the size field in your update query. It will then update 291 of the 300 records. The other 9 records are not updated because they have a blank size or a size that does not occur in the offset table.

Posting Permissions

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