改为String sql="select * from WorkRecord where WorkTime BETWEEN #1999-1-1# AND #2004-4-1#";可行但是用String StartTime="#1999-04-1#"; String EndTime="#2004-12-12#";String sql="select * from WorkRecord where WorkTime BETWEEN '"+StartTime+"' AND '"+EndTime+"'"; 将出现 DateConn.executeDelete:[Microsoft][ODBC Microsoft Access 驱动程序] 标准表达式 数据类型不匹配。
你为什么加单引号? String sql="select * from WorkRecord where WorkTime BETWEEN "+StartTime+"AND "+EndTime;
String EndTime="#2004-12-12#";String sql="select * from WorkRecord where WorkTime BETWEEN '"+StartTime+"' AND '"+EndTime+"'";
将出现
DateConn.executeDelete:[Microsoft][ODBC Microsoft Access 驱动程序] 标准表达式
数据类型不匹配。
String sql="select * from WorkRecord where WorkTime BETWEEN "+StartTime+"AND "+EndTime;