CODEWITHSUNDEEP
ms-access
eoinone
eoinone

Reputation: 45

access DLookUp multiple criteria

having trouble with this DlookUp expression it evaluates the first criteria but not the other two, any advice would be great.

App_Ref is a text box, PRB responsable is a string, AppCostAdmend is a string

 =DLookUp("[Var_Amount]","Variations","[Var_AppRef] =[App_Ref]" And "[Var_Type] =  'AppCostAdmend'" And "[Var_Description] = 'PRB responsable'")

Upvotes: 0

Views: 15611

Answers (1)

dwo
dwo

Reputation: 3636

The AND has to be part of the criteria too! It works like a SELECT with WHERE ... AND ...!

So:

=DLookUp("[Var_Amount]","Variations","[Var_AppRef] =[App_Ref] And [Var_Type] =  'AppCostAdmend' And [Var_Description] = 'PRB responsable'")

Upvotes: 2

Related Questions