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