如题,谢谢大家了
select * from 进货表 where 进货表.日期 between '" + Str(DTP1.Value) + "'AND '" + Str(DTP2.Value) + "'select * from 进货表 where (进货表." & Combo1.text & " like'%'+ '" + Text1.text + "'+'%')select count(*)as pz,sum(数量)as 数量1,sum(金额)as 金额1 from 进货表 where (进货表." & Combo1.text & " like +'%'+ '" + Text1.text + "'+'%')里面有的引号是什么意思啊 “&Combo1.text&”
还有like后面加‘%’大家帮帮忙
select * from 进货表 where 进货表.日期 between '" + Str(DTP1.Value) + "'AND '" + Str(DTP2.Value) + "'select * from 进货表 where (进货表." & Combo1.text & " like'%'+ '" + Text1.text + "'+'%')select count(*)as pz,sum(数量)as 数量1,sum(金额)as 金额1 from 进货表 where (进货表." & Combo1.text & " like +'%'+ '" + Text1.text + "'+'%')里面有的引号是什么意思啊 “&Combo1.text&”
还有like后面加‘%’大家帮帮忙
&表示连接
还有like后面加‘%’
%表示指代任字符
--查询进货表中进货日期在DTP1.Value和DTP2.Value之间的数据
select * from 进货表 where (进货表." & Combo1.text & " like'%'+ '" + Text1.text + "'+'%')
--查询进货表中栏位Combo1.text 中像Text1.text的记录 select count(*)as pz,sum(数量)as 数量1,sum(金额)as 金额1 from 进货表 where (进货表." & Combo1.text & " like +'%'+ '" + Text1.text + "'+'%') --求进货表中栏位Combo1.text 中像Text1.text的记录的进货笔数,进货数量和金额