Merging fields in diff tables

[Dorothy]

I have 2 tables with one field that is the same (SS#).
In Table 1 I have 2 fields (BU and Matric) that I'd need
to get into Table 2, but only where the SS#s match. (So in
the end, some of the records in Table 2 will not have info
in these 2 fields). How do I accomplish this? I
appreciate your help. Thanks.

 

[Jeff Boyce]

Dorothy

Sounds like an update query. By the way, is there a significant business
need to have the same data in two tables? Generally, this is not a good
idea.

Good luck

Jeff Boyce
<Access MVP>