rs.open "select * from hhh WHERE year(日期)=year('" & text1.text & "')"
rs.open "select * from hhh WHERE month(日期)=month('" & text1.text & "')"
rs.open "select * from hhh WHERE day(日期)=day('" & text1.text & "')"
rs.open "select * from hhh WHERE month(日期)=month('" & text1.text & "')"
rs.open "select * from hhh WHERE day(日期)=day('" & text1.text & "')"
我只是提示你应该用 Year()、Month()、Day() 函数!你的问题描述的本身就不是很清楚!
select * from hhh where 日期=“%%%%1213”