Update Query or Append

[Guest]

How would I do this? I have a table ApplicantsTbl and a table
UpdatedApplicantsTbl. The fields are identical. The updated table will have
3 or 4 records that need updated to the main ApplicantsTbl. The ApplicantID
is the primary key in both and this number will match the records in both
that I want to update. How would I make an update query, that will take
ApplicantID XXX from UpdatedApplicantsTbl and replace the information with
AplicantID XXX in ApplicantsTbl. I want to mesh the two tables and the
UpdatedApplicantsTbl has the most current information. Each time I do this
the ApplicantID will be different.

 

[John W. Vinson]

How would I do this? I have a table ApplicantsTbl and a table
UpdatedApplicantsTbl. The fields are identical. The updated table will have
3 or 4 records that need updated to the main ApplicantsTbl. The ApplicantID
is the primary key in both and this number will match the records in both
that I want to update. How would I make an update query, that will take
ApplicantID XXX from UpdatedApplicantsTbl and replace the information with
AplicantID XXX in ApplicantsTbl. I want to mesh the two tables and the
UpdatedApplicantsTbl has the most current information. Each time I do this
the ApplicantID will be different.

Create a Query joining ApplicantsTbl to UpdatedApplicantsTbl by ApplicatnID (a
one to one relationship since they're both primary keys). Change the query to
an Update query (since you want to update existing records, rather than adding
new records which an Append query would do).

On the UpdateTo line under field XXX put

[UpdatedApplicantsTbl].[XXX]

using the matching real field name, on each field that you want updated. The
brackets are required (so Access will look in the field in the table, rather
than updating the field to the text string "UpdatedApplicantsTbl.XXX").

Run the query with the ! icon and you should be in clover.

John W. Vinson [MVP]