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 ")