Dear all,
When I try to run an append query,
the following field: InventoryID: DLookUp("[InventoryID]","InventoryTable","InventoryName=" & [RecipeTable]![RecipeName])
creates this error message: Syntax error in string in query expression 'InventoryName = Jim's Mayo'.
Please help.
Thanks