关于月份查询的问题
Dim ssql1 As String
Dim cnn1 As New adodb.Connection
Dim ret1 As New adodb.Recordset
Const a = "'"
temp = Year(Date)
temp1 = Month(Date)
temp2 = temp & "-" & temp1
'连接数据库
cnn1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path & "\data\kq.mdb" + ";Persist Security Info=False;"
ssql1 = "select 编号,提成,月份 form 收银 Where format(月份,'yyyy-mm') ='" & temp2 & "' And 编号 = '" & text1.Text & "'"
Debug.Print ssql1
ret1.Open ssq1l, cnn1
If ret1.BOF And ret1.EOF Then
MsgBox "没有这个会员", , "警告"
Else
Text4.Text = ret1.Fields("提成")
Text5.Text = ret1.Fields("收取费用")
ret1.Close
cnn1.Close
End If
以上代码出错,提示数据类型出错