时间应该用什么符号扩起来?
Dim tempdbs As Database
Dim temprst As Recordset
Set tempdbs = OpenDatabase(App.Path + "/sign1.mdb")
Set temprst = tempdbs.OpenRecordset("select * from usualday ",dbOpenSnapshot)
Dim tempstring As String
tempstring = "time>'2003/3/22 13:00:00'"
With temprst
.MoveLast
.FindFirst tempstring
end with
time是usualday表中的一个时间型字段,
出现错误提示:标准表达式中数据类型不匹配
我怀疑是时间不应该用''来引起来,应该用什么?应该怎么改,急啊