ACCESS中的严重问题

[szyhy810518]

SELECT WorkSN,Name,PositionSN,WorkPosition,DepartmentSN,Department,ScheduleName,FromTime,ToTime,OnWorkTime,OffWorkTime,Exceptional FROM vwChecks WHERE (FromTime BETWEEN #2003-10-1 0:00:01# AND #2003-10-23 23:59:59#) AND (ToTime BETWEEN #2003-10-1 0:00:01# AND #2003-10-23 23:59:59#) AND (WorkSN LIKE '%%') AND (Name LIKE '%%') AND ((Exceptional='99') OR (Exceptional='11') OR (Exceptional='12')) ORDER BY FromTime,OnWorkTime

以上语句在VB+ACCESS中可以查询到记录,然而在ACCESS中直接查询却无任何记录,也不报什么错误!

求解?

[hhjjhjhj]

也没多少参数吗
一个一个减少地试，看什么时候会正常

[lion_wing]

逻辑错误！！