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

    Set to 0 (Access 2000)

    How can i set to 0 the field grossprice in the following query ?

    SELECT products.Productid, products.grossprice, products.ddu, products.office, ([office]-[ddu])/[office] AS Pctmargin, [office]-[ddu] AS Margin
    FROM products
    WHERE (((products.grossprice)>0) AND (([office]-[ddu])<0));

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Set to 0 (Access 2000)

    Your query is a select query. If you want to change the value of a field, you need an update query.
    - Open the query in design view.
    - Select Query | Update Query.
    - You will see a new row in the query design window: Update to.
    - Enter 0 in the "Update to" line for the grossprice column.
    To execute the update query, select Query | Run or click the Run button on the toolbar.

Posting Permissions

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