是呀 SELECT DB_FIELD_1,DB_FIELD_2 ,.. FROM TABLE_1 WHERE TABLE_1.DATA_FIELD BETWEEN TO_DATE(text1.text,'dd/MM/yyyy) AND TO_DATE(text2.text,'dd/MM/yyyy) AND TABLE_1.ID = text3.text
select * from yourtablename where time>=text1.text and time<=text2.text and 编号=text3.text不就ok拉 什么地方不明白阿!!
select * from table where time>='" & text1.text &"' and time<='" & text2.text &"' and 编号=" & text3.text &"
SELECT DB_FIELD_1,DB_FIELD_2 ,..
FROM TABLE_1
WHERE TABLE_1.DATA_FIELD BETWEEN TO_DATE(text1.text,'dd/MM/yyyy) AND TO_DATE(text2.text,'dd/MM/yyyy)
AND TABLE_1.ID = text3.text
where time>=text1.text and time<=text2.text and 编号=text3.text不就ok拉
什么地方不明白阿!!
where time>='" & text1.text &"' and time<='" & text2.text &"' and 编号=" & text3.text &"
同 李洪根.