Dim txt As
String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("窗口1_Table1")
If txt = "" Then
tbl.Filter = ""
Else
txt = "'%" & txt & "%'"
tbl.Filter = "客户ID Like
" & txt & " Or
公司名称 Like
" & txt & " Or 地址
Like " & txt & " Or 联系人 Like " & txt
End
If
查询时,如果地址出现为空值,且查询时未输入查询条件,结果查询结果查询不到此项纪录了,请问有like怎么查询空值??
目前是采用if 出现空值,结果不筛选此项,但是这个空值列多怎么处理??