访问 DLookUp 多个条件 [英] access DLookUp multiple criteria

问题描述

这个 DlookUp 表达式有问题，它评估第一个条件，而不是其他两个，任何建议都会很好.

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

App_Ref 是一个文本框，PRB responsable 是一个字符串，AppCostAdmend 是一个字符串

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'")

推荐答案

AND 也必须是标准的一部分！它就像一个带有 WHERE ... AND ... 的 SELECT！

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

所以:

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

这篇关于访问 DLookUp 多个条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！