troubleshooting Question

Access 2016 DLookUp systax

Avatar of Larry Fisackerly
Larry Fisackerly asked on
Microsoft Access
6 Comments2 Solutions147 ViewsLast Modified:
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?
Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros