Multiple Criteria in Dlookup (access)

5 pts.
Tags:
Access 2016
Access SQL
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' how do I add that?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    try adding anothe ste of parenthesis
    On hand FG: DLookUp("ML_QTY","ML",("[ML_IMKEY] = '" & [IM_Key] & "' and ML_LOCATION like 'B-*'")) 

    135,485 pointsBadges:
    report
  • TheRealRaven
    Please clarify, ideally with data examples.

    You currently have "ML_LOCATION like 'B-*'" but you need to add "ML_LOCATION = 'FG'".

    Since those are contradictory, you need to explain exactly what results you need.
    36,420 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: