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

 like会剔除空值。你要这样写，比如 (id like '%%' or id is null)

 换行看这里 http://www.foxtable.com/help/topics/2489.htm

 换行，比如这样改

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)

like问题，请按照2楼修改。

那就参考这种写法，动态合成sql语句。

http://www.foxtable.com/help/topics/1058.htm