compare two tables and update

[Guest]

i have a table a and table b / Both tables have the same primary key field
LSE NO / many of the fields in both tables are identical / where the primary
keys match i would like to have table a check table b's identical fields and
update table a if table a has a null record / thanks gary

 

[Joseph Meehan]

i have a table a and table b / Both tables have the same primary key
field
LSE NO / many of the fields in both tables are identical / where the
primary keys match i would like to have table a check table b's identical
fields and update table a if table a has a null record / thanks gary

A little work with and update query.

The help file as some good information on the subject.

 

[Guest]

I have been able to use the update wizard to select the two tables involved,
note what fields are to be updated, but when I try and put "is null"
in as criteria I get 0 returns. If I try one field at a time it works
great, but I have multiple fields to update,.....hellllpppp. thanks