时间查询

Question

在ACCESS中查询一个时间段如何写sql

Answer 1

if Radio3.Checked=true then
     begin
       with data.query1  do
         begin
           close;
           sql.Clear;
           sql.add('select * from 表1 where 日期 between #'+formatdatetime('mm/dd/yyyy',datetimepicker1.DateTime)+'# and #'+formatdatetime('mm/dd/yyyy',datetimepicker2.DateTime)+'#');
           open;
         end;
      end;