ACCESS数据库中出现“标准表达式中数据类型不匹配”，奇怪～
Microsoft JET Database Engine 错误 '80040e07 '
标准表达式中数据类型不匹配。
/HyMoneyLog.asp，行 25
相关代码：
dtfrom=trim(request( "dtfrom "))
dtto=trim(request( "dtto "))
if len(dtfrom)=0 then
dtfrom=year(now)& "- "& mm & "-01 "
end if
if len(dtto)=0 then
dtto=thistoday
end if
set HyRs=server.CreateObject( "adodb.recordset ")
set HyRs=nothing
set HyRs=server.CreateObject( "adodb.recordset ")
sql = "SELECT * from HyPacketList where optime> = ' " & dtfrom & " ' and optime <= ' " & dtto & " ' order by optime desc "
'Response.Write sql
'Response.End
HyRs.Open sql,conn
j=HyRs.RecordCount
========应该是日期的问题，AC数据库里类型选择了“时间/日期”
[解决办法]
sql = "SELECT * from HyPacketList where optime> =# " & dtfrom & "# and optime <=# " & dtto & "# order by optime desc "
[解决办法]
楼上正解~
