I have table tbl_Master Contacts Mailable with contact fields including Zip5 (zip codes).
I have table tbl_Counties Zip Codes with Zip Codes and Counties.
I need to use Access 2016 DLoopUP to add the counties from tbl_counties Zip Codes to the matching Zip5 in tbl_Master Contacts Mailable.
I get the following error: The expression entered contains invalid syntax. You may have entered an operand without an operator.”
find_county:DLookUp (“[County]”,”tbl_Counties Zip Codes”,”[Zip Code]='"&[Zip5]""')
What is the proper coding?