I am having trouble getting this query to find records to update. I know there are matches because this was previously done in Excel.
UPDATE tblTestData, tblBusinessRules1
SET tblTestData.DESTINATIONSTATE = tblBusinessRules1.DESTINATIONSTATE
AND tblTestData.DESTINATIONCITY=tblBusinessRules1.DEST INATIONCITY
AND tblTestData.[#BUSRULE]=1
WHERE ((tblTestData.NAMEFUNCTION=tblBusinessRules1.NAMEF UNCTION)
And (tblTestData.CITY=tblBusinessRules1.CITY)
And (tblTestData.ST=tblBusinessRules1.ST)
And (tblTestData.COM4_DESC=tblBusinessRules1.COM4_DESC )
And (tblTestData.USPORT=tblBusinessRules1.USPORT)
And (tblTestData.FPORT=tblBusinessRules1.FPORT)
And (tblTestData.ULTPORT=tblBusinessRules1.ULTPORT)
And (tblTestData.SLINE=tblBusinessRules1.SLINE));