Results 1 to 5 of 5

Thread: Update table where criteria depends on other table column for Access 2000 [RESOLVED]

Threaded View

  1. Feb 7th, 2006, 10:14 PM #1
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Resolved Update table where criteria depends on other table column for Access 2000 [RESOLVED]

    i got 2 table..table1, table2(which is like the duplicate for table2 for specific reason in my company)

    table1 = col1 + qty
    table2 = date_now + col1 + qty

    every month table2's content is change according to what table1 has..but somehow (not sure why it happens) it only inserted date_now and col1..

    so now i need to update table2.qty where the table2.col1 = table1.col1..
    is it possible? can't figure it out what the syntax are

    thx
    Last edited by erickwidya; Feb 8th, 2006 at 09:05 PM. Reason: forgot to mention the Database

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width