又一个ACCESS查询问题

[liujin9012]

SELECT c.MR_Number as 货料编号, c.MR_Name as 货料名称, c.MR_Model as 规格型号, c.MR_Unit as 单位, a.InInfo_Number as 数量, a.InInfo_Price as 单价, b.InSingle_Supplier as 供应商, b.InSingle_Date as 日期 FROM (MIS_InsertInfo as a INNER JOIN MIS_InsertSingle as b ON a.InInfo_InsingleID = b.InSingle_Number) INNER JOIN MIS_MaterielRegiser as c ON a.InInfo_InMaReID = c.MR_Number where cast(b.InSingle_Date as datetime) between '2012-04-05 00:00:00.000' and '2012-04-06 00:00:00.000'

这个SQL 语句在SQL Server里能执行成功，但是放在ACCESS里就报错了。问题是出在cast(b.InSingle_Date as datetime)这里，但怎么改呢。

[WWWWA]

format(b.InSingle_Dat,'yyyy-mm-dd hh:mm:ss') between '2012-04-05 00:00:00' and '2012-04-06 00:00:00'

[liujin9012]

[Quote=引用 1 楼 的回复:]

format(b.InSingle_Dat,'yyyy-mm-dd hh:mm:ss') between '2012-04-05 00:00:00' and '2012-04-06 00:00:00'
[/Quote]OK，Thank you!