compare two tables and update

P

proenergy

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
 
P

proenergy

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
 
Top