Adding new records and updating existing records from different ta

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CBeavers - 13 May 2008 00:00 GMT

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.

Reply to this Message

Douglas J. Steele - 13 May 2008 01:20 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I am working in Access 2003.
>
[quoted text clipped - 13 lines]
> StuID's
> and 15 fields of data that aren't in tblBenchmark.

Reply to this Message

Rate this thread: