VB统计符合查询条件的记录数

来源：百度知道 编辑：UC知道 时间：2024/06/14 18:21:33
代码如下:
SQL = "Select count(*) From [发票] where (船号 like '%combo1.text%')and(日期 like '%" & Combo3.Text & "%')"
Conn.CursorLocation = adUseClient
Rs.Open SQL, Conn, 3, 2
text1.Text = Rs.RecordCount
可是结果显示为1,改查询条件也是1,到底是哪错了?那位大侠帮帮忙!

SQL = "Select count(*) as cou From [发票] where (船号 like '%combo1.text%')and(日期 like '%" & Combo3.Text & "%')"
Conn.CursorLocation = adUseClient
Rs.Open SQL, Conn, 3, 2
text1.Text = Rs("cou")

combo1.text两边少了&连接符

SQL = "Select count(*) From [发票] where (船号 like '%" & combo1.text & "%')and(日期 like '%" & Combo3.Text & "%')"