Adding new records and updating existing records from different ta

C

CBeavers

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import excel dat to update and add new records 1
Referential Integrity 6
Import new data and replace old data in Access table. 4
How do I update existing records within a database? 3
Access Access 2010 import/append data into table w/o overwriting existing records 0
2007 Can't update existing information with email data collection 4
Import Updated Data from and Excel to Access 2
Importing from a spreadsheet, update or append query? 5

Top