I have been trying to add multiple criteria to a dlookup and cant get the syntax correct.
Code
On hand FG: DLookUp("ML_QTY","ML","[ML_IMKEY] = '" & [IM_Key] & "' and ML_LOCATION like 'B-*'")
I need to add ML_LOCATION = 'FG' as well how do I add that?