Adding new records and updating existing records from different ta

[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.

 

[Douglas J. Steele]

See my November, 2003 "Access Answers" column in Pinnacle Publication's
"Smart Access". You can download the column (and sample database) for free
from http://www.accessmvp.com/DJSteele/SmartAccess.html