Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Myanmar (Burma)
    Posts
    42

    Red face Unanswered: How to add a data into existing record(s)?

    Hi Access Guru

    My problem is that...

    I've a temp table which construct with 6 fields.
    Four of them will filled once.
    After that the last two field will be fill after a checking process.

    Those fields are IDate and IRefNo.
    Every records of that table have the same IDate and IRefNo.

    Thanks in advance.
    Cyber : The easiest place to make huge mistake.

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Update table
    set columnA = x, columnB = y
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jan 2004
    Location
    Myanmar (Burma)
    Posts
    42
    Originally posted by r123456
    Update table
    set columnA = x, columnB = y
    Thanks for your hint.
    But I'm not very clear. Can you tell me more details pls.

    Thanks
    Cyber : The easiest place to make huge mistake.

  4. #4
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Code:
    SQL> select * from test;
    
          VAR1    IDate     IRefNo
    ----------    ----------  ---------
             1
             2
    
    update test
    set IDate = '19/feb/04', IRefNo = 1;
    
    SQL> select * from test;
    
          VAR1    IDate        IRefNo
    ----------    ----------    ---------
             1      19-FEB-04      1
             2      19-FEB-04      1
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  5. #5
    Join Date
    Jan 2004
    Location
    Myanmar (Burma)
    Posts
    42
    Originally posted by r123456
    Code:
    SQL> select * from test;
    
          VAR1    IDate     IRefNo
    ----------    ----------  ---------
             1
             2
    
    update test
    set IDate = '19/feb/04', IRefNo = 1;
    
    SQL> select * from test;
    
          VAR1    IDate        IRefNo
    ----------    ----------    ---------
             1      19-FEB-04      1
             2      19-FEB-04      1
    Thanks again Guru
    Cyber : The easiest place to make huge mistake.

Posting Permissions

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