Dlookup的用法
lm_jm 2011-05-24 12:29:36 您好,我在文本框的控件来源,的表达式生成中,输入如下的格式,但是获取值错误。麻烦帮我看看是哪里出现问题了,谢谢!Stardate,orderdate是日期型
=DLookUp("Target","Porosity Target Seting","stardate<'" & Forms![Porosity data Form2]!Orderdate & "' and enddate>'" & Forms![Porosity data Form2]!Orderdate & "'")