Help with Query?

Lstclair55 said:

tblProperty and tblValuations

I want to compare the PropNumr and Streetname fields in tbl Property to the the equivalent fields in tblValuations. If there is a match, I want to transport / copy across the ValuerID field in tblValuations to tblProperty.

Any ideas?

Click to expand...

UPDATE [tbl Property], [tblValuations] SET
[tblValuations].[ValuerID]=[tbl Property].[ValuerID]
WHERE ([tbl Property].[PropNumr])=[tblValuations].[PropNumr]) 
AND ([tbl Property].[Streetname]=[tblValuations].[Streetname]);