Link to home
Start Free TrialLog in
Avatar of Larry Fisackerly
Larry Fisackerly

asked on

Access 2016 DLookUp systax

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?
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Larry Fisackerly
Larry Fisackerly

ASKER

I pasted the DLoopUP code you sent back. I got the same error. What now?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That worked. Thanks.
Larry,

Don't forget to close out the question.
Question is answered.