Update Query Question/Problem

[Guest]

Hi,

I have the following for an update query:

UPDATE tNEW RIGHT JOIN t05 ON tNEW.[Cust Material Number] = t05.[Cust
Material Number] SET tNEW.[Vendor Material Number] = t05.[Vendor Material
Number], tNEW.[Part Class] = t05.[Parts Class]
WHERE (((tNEW.[Vendor Material Number]) Is Null));

In checking to see the records that will be updated, it is returning those
in the Cust Material Number field that are null (only 10 records) and there
are many more that have null values in Vendor Material Number.

Can anyone tell me what I need to do to have it update the blank field in
Vendor Material Number in tNew when there are matches for Cust Material
Number in t05?

Your help is greatly appreciated!
Pam

 

[Guest]

Please disregard post - I've figured it out. Needed to change "Is Null" to
"'".