加好友 发短信
等级:八尾狐
帖子:1838
积分:13006
威望:0
精华:0
注册:2013/6/10 9:23:00
|
[求助]模糊查询 Post By:2019/9/2 9:16:00 [显示全部帖子]
'tbl.Filter = "发货单号 = '" & Tables("商业主表").Current("fa piao编号") & "'" And ("装箱单号 Like " & txt & " Or 发货单号 Like " & txt & " Or 工作号 Like " & txt & " Or 客户编号 Like " & txt & " Or 产品ID Like " & txt & " Or 产品名称 Like " & txt & " Or 世源图号 Like " & txt & " Or 产品图号 Like " & txt & " Or 产品材料 Like " & txt & " Or 产品规格 Like " & txt & ")"
模糊查询加个一个条件, 请老师帮忙修改一下!
|
|