quick easy database query help

Discussion in 'Databases' started by retrocode0071, Jan 18, 2008.

0
  1. #1
    I want this in one query and yes it is ms access which I’m growing to loath.

    UPDATE Tanks SET Tanks.[Paragraph #] = 3 WHERE Tanks.Secondary=-1;
    UPDATE Tanks SET Tanks.[Paragraph #] = 4 WHERE Tanks.Secondary=0;

    thanks everyone
     
    retrocode0071, Jan 18, 2008 IP
  2. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #2
    I think this will work:

    UPDATE Tanks SET Tanks.[Paragraph #] = 4+Tanks.Secondary WHERE Tanks.Secondary=0 or Tanks.Secondary=-1;
     
    Kuldeep1952, Jan 18, 2008 IP
  3. retrocode0071

    retrocode0071 Banned

    Messages:
    719
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I am not sure it would update one to be 3
     
    retrocode0071, Jan 18, 2008 IP