DTPicker+access解决办法

2012-01-07

DTPicker+accessSQLselect*fromSKInformationa,ArkInfobwherea.idb.idandb.CheckInDate &_DTStar.Va

DTPicker+access
SQL = "select * from SKInformation a,ArkInfo b where a.id=b.id and b.CheckInDate> = ' " & _
DTStar.Value & " ' and CheckInDate <= ' " & DTEnd.Value & " ' "
在SQL里可以運行,在ACCESS中不能運行哦!555555555555
換成#號也沒用,555555555555高手幫幫忙哦!

[解决办法]
format(DTEnd.Value, "yyyy-mm-dd ")