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.