呵呵,合成表达式的问题,楼主你好好看看:
http://www.foxtable.com/help/topics/1284.htm
http://www.foxtable.com/help/topics/2919.htm
http://www.foxtable.com/help/topics/1058.htm
你4楼红色的代码,简直不堪入目,先看一下上面的帮助,然后自己改一下,这是基本工功,不会岂能编程?
你已经二尾狐了,不是新手啦。
ex.Filter = "[客户名称] like '%" & khmc.text & "%'“
if e.Form.Controls("日期1").Value & is Not Nothing Then
ex.Filter = ex.Filter & ” And [日期] >= #“ e.Form.Controls("日期1").Value & "#"
End if
if e.Form.Controls("日期2").Value & is Not Nothing Then
ex.Filter = ex.Filter & ” And [日期] <= #“ e.Form.Controls("日期2").Value & "#"
End if

[此贴子已经被作者于2014-3-19 10:34:10编辑过]