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

    Update query (Access 2000)

    I want to make an update query update the grossprice with 1,0 however the update query does not open. What may be the reason ? My query is :
    UPDATE products SET products.grossprice = products.grossprice+2;

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Update query (Access 2000)

    Update queries don't open, the just run.
    When they run you don't see anything happen, but the data should have been changed.

    In this case, each time you run it the grossprice will increase by 2.
    Regards
    John



Posting Permissions

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