[求助]多条件筛选在遇到空值单元时筛选结果不正确 Post By:2018/5/4 10:50:00 [只看该作者]
Dim txt1 As String = e.Form.Controls("TextBox1").Text Dim txt2 As String = e.Form.Controls("TextBox2").Text Dim txt3 As String = e.Form.Controls("TextBox3").Text Dim tbl As Table = Tables("查询_table1")
txt1 = "'%" & txt1 &"%'" txt2 = "'%" & txt2 &"%'" txt3 = "'%" & txt3 &"%'" tbl.Filter = "名称 Like " & txt1 & " and 规格型号 Like " & txt2 & " and 供应商 Like " & txt3 以上是筛选代码,在需要筛选的单元格中如果有空值,则会被跳过,哪怕其它筛选条件都符合。比如说某个物品规格型号为空,那么在筛选的时候如何将这个没有规格型号的物品也筛选出来,而不是作为条件不符合被筛选掉。 大神求解惑