好像不是java的问题吧。
access中关于日期查询的标准SQL为:
select fldQ FROM tbData where fldID=1 and fldDate< "+"#" + queryDate +"#"
access中关于日期查询的标准SQL为:
select fldQ FROM tbData where fldID=1 and fldDate< "+"#" + queryDate +"#"
调试欢乐多
试试楼上的即可
ls_1="select fldQ FROM tbData where fldID=1 and fldDate< "+"#" + queryDate.toLocaleString () +"#";