Hi,

I have 2 tables in one Access database: Contact Db and Client Db. I want to update Contact Db and set the field CompanyName equal to the related Client's Name (field: Name1) if it is does not already have a value.

I have written this:
UPDATE [Contact Db]
SET CompanyName = [Client Db].Name1
WHERE Len(Nz(CompanyN ame)) = '0'
AND [Contact Db].ClientNumber = [Client Db].CustomerNumber ;...