1,502
社区成员
发帖
与我相关
我的任务
分享
'字符型
Dim str1 As String
str1 = "select * from buyrecord where 用户编号 = '" _
& CStr(表示编号的变量) _
& "'"
'日期型
Dim str2 As String
str2 = "select * from buyrecord where 购买日期 = #" _
& CStr(表示日期的变量) _
& "#"
'数值型
Dim str3 As String
str3 = "select * from buyrecord where 购买数量 = " _
& CStr(表示数量的变量)
'字符型
Dim str1 As String
str1 = "select * from buyrecord where 用户编号 = '" _
& CStr(BianHao) _
& "'"
'日期型
Dim str2 As String
str2 = "select * from buyrecord where 购买日期 = #" _
& CStr(BianHao) _
& "#"
'数值型
Dim str3 As String
str3 = "select * from buyrecord where 购买数量 = " _
& CStr(BianHao)