Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007
    Posts
    14

    Unanswered: Updating existing records and adding new

    I am working in Access 2003.

    I have two tables tblBenchmarks and tblBenchmarkUpdates.
    I need to update existing records in tblBenchmark and also add new records if they currently do not exist in tblBenchmarks.

    tblBenchmarkUpdates has both existing and new records that need to be added to tblBenchmark.

    I need to add data to fifteen existing fields that are currently null in tblBenchmark.

    I need to identify existing StuId (primary key). Update the data from tblBenchmarkUpdate to those records in tblBenchmark and add the new StuID's and 15 fields of data that aren't in tblBenchmark.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

  3. #3
    Join Date
    Sep 2007
    Posts
    14
    Quote Originally Posted by pbaldy
    Thank you for that link! It was very easy to follow.

Posting Permissions

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