About Pricing Community Teams Start Free Trial

SteveL13

asked on 2/13/2018

Syntax issue in DLookup

I'm getting a syntax error with:

= DLookup("[QtyTransferred]", "query3", "[OwnerName] = 'John Doe ABC' & " AND [Crop] = '" & [Reports]![rptInventoryOwnership]![txtCrop2] & "'")

NOTE: An expert helped me with a very similar issue a couple of days ago. I hope someone can figure this one out for me.

Microsoft Access

Last Comment

Anders Ebro (Microsoft MVP)

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

2/13/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

Anders Ebro (Microsoft MVP)

2/13/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

Plans and Pricing

Certified Expert Program

Credly Partnership

Udemy Partnership