主题：[求助]帮忙分析一下，处理一下，谢谢

我这个句子，每加一个LIKE，查询出来的信息就会少一部分，不知道是什么原因，另外，我一个句子很长，怎么拆分换行呀，

Tables("jiankong_table1").Fill("Select ID As 系统编号,changjia As 客户,pici As 批次,songdanwei As 单位,pinpai As 屏品牌,xinghao As 屏型号,bianma As 屏编码,xuliehao As 屏序列号,beijianid As 备件条码,leibie As 类别,guzhang As 原始故障,danjuzhuangtai as 单据状态 From main where id like '%" & bh.text & "%' and beijianid like '%" & bj.text & "%' and xinghao like '%" & xh.text & "%' and changjia like '%" & kh.Text & "%' and pici like '%" & pc.text & "%' And danjuzhuangtai Like '%" & dj.Text & "%' and zjzhuangtai Like '%" & zjzt.Text & "%' and jieshoujigou = '" & _UserGroup & "'","User",True)