Probably Simple...

[Guest]

Just wanting to know the criteria to update the values of one field with the
same values of another field in the same table. Ex: Where address1 field is
null, update the values from the adjacent address2 field. Thank you!

 

[Rick Brandt]

Just wanting to know the criteria to update the values of one field
with the same values of another field in the same table. Ex: Where
address1 field is null, update the values from the adjacent address2
field. Thank you!

UPDATE TableName
SET [TableName]![Field1] = [TableName]![Field2]
WHERE [TableName]![Field1] Is Null

 

[Guest]

Thank you Rick, that worked great

Just wanting to know the criteria to update the values of one field
with the same values of another field in the same table. Ex: Where
address1 field is null, update the values from the adjacent address2
field. Thank you!

UPDATE TableName
SET [TableName]![Field1] = [TableName]![Field2]
WHERE [TableName]![Field1] Is Null