procedure TForm4.BitBtn1Click(Sender: TObject);
begin
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.ConnectionString:=('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=zysb.mdb;Persist Security Info=False');
adoquery1.sql.add('select 日期 as Tdate,姓名 as Tname,积休事由 as jxsy,积休天数 as ts');
adoquery1.sql.add(' from jxj');
adoquery1.sql.add('where str(日期)>='+#39+datetimetostr(DateTimePicker2.date)+#39+' and str(日期)<='+#39+datetimetostr(DateTimePicker3.date)+#39+' order by 日期');
adoquery1.Open;if adoquery1.Recordcount=0 then
showmessage('报表中没有可用数据!')
else
RvProject1.Execute;
end;
///////其中"日期"是acess中的日期时间型,每次都选择不到自己的需要的日期范围内的数据,前面的日期大于后面的时,还能取到数据!!/////////////////
begin
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.ConnectionString:=('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=zysb.mdb;Persist Security Info=False');
adoquery1.sql.add('select 日期 as Tdate,姓名 as Tname,积休事由 as jxsy,积休天数 as ts');
adoquery1.sql.add(' from jxj');
adoquery1.sql.add('where str(日期)>='+#39+datetimetostr(DateTimePicker2.date)+#39+' and str(日期)<='+#39+datetimetostr(DateTimePicker3.date)+#39+' order by 日期');
adoquery1.Open;if adoquery1.Recordcount=0 then
showmessage('报表中没有可用数据!')
else
RvProject1.Execute;
end;
///////其中"日期"是acess中的日期时间型,每次都选择不到自己的需要的日期范围内的数据,前面的日期大于后面的时,还能取到数据!!/////////////////
And DATEDIFF("d", 订购日期, '++#39+datetimetostr(DateTimePicker3.date)+#39+') >= 0
And DATEDIFF("d", 订购日期, '+#39+datetimetostr(DateTimePicker3.date)+#39+') >= 0
adoquery1.sql.add('where str(日期)>='+#39+datetimetostr(DateTimePicker2.date)+#39+' and str(日期)<='+#39+datetimetostr(DateTimePicker3.date)+#39+' order by 日期');
And DATEDIFF("d", 订购日期, '+#39+datetimetostr(DateTimePicker3.date)+#39+') >= 0 order by 日期');
begin
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.ConnectionString:=('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=zysb.mdb;Persist Security Info=False');
adoquery1.sql.add('select 日期 as Tdate,姓名 as Tname,积休事由 as jxsy,积休天数 as ts');
adoquery1.sql.add(' from jxj');
adoquery1.sql.add('Where DATEDIFF("d", 订购日期, '+#39+datetimetostr(DateTimePicker2.date)+#39+') <= 0
And DATEDIFF("d", 订购日期, '+#39+datetimetostr(DateTimePicker3.date)+#39+') >= 0 order by 日期');if adoquery1.Recordcount=0 then
showmessage('报表中没有可用数据!')
else
RvProject1.Execute;
end;
2-->2
0-->0
0-->0
6-->6
1-->1
2-->2
6-->3!!!!!!!
强烈鄙视技术问题解决后把贴子转移到非技术区的人!
鄙视你们!http://community.csdn.net/Expert/topic/5216/5216675.xml?temp=.9262659