Dim G_Conn As New ADODB.Connection
Dim G_Rst As New ADODB.Recordset
G_Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\db1.mdb;Persist Security Info=False"
SQL = "select count(distinct 字段) as ss from 123456 where 字段=" & CCur(txt3.Text) & ""
Set G_Rst = G_Conn.Execute(SQL1)
txt7.Text = G_Rst!sscount(distinct 字段) ???没有写对吗?
Dim G_Rst As New ADODB.Recordset
G_Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\db1.mdb;Persist Security Info=False"
SQL = "select count(distinct 字段) as ss from 123456 where 字段=" & CCur(txt3.Text) & ""
Set G_Rst = G_Conn.Execute(SQL1)
txt7.Text = G_Rst!sscount(distinct 字段) ???没有写对吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货