sql="select * from [record] where inTime between #2007-12-01# and #2007-12-30#"相应的换成变量就可以了
sql="select * from [record] where inTime between #2007-12-01# and #2007-12-30#"变更一下就行了
sql用between andselect * from 表where time between 2009-11-1 00:00:00 and 2009-11-9 00:00:00