小弟下载了下载中心栏的<<使用用户归档实现报表简介>>
使用的时候发现一些问题,程序运行之后,每当小时变化的时候,会自动记录,但是每次点击查询测试会依次跳出3个对话框,("&sqlriqijiu.Value&"%这个为设置的日期%)
"select avg(var1),avg(var2),avg(var3),avg(var4),avg(var5),avg(var6),avg(var7),avg(var8),avg(var9),avg(var10) from UA#DailyReport where riqijiu like '"&sqlriqijiu.Value&"%' and shijianjiu between 0 and 7 "
select shijianjiu,var1,var2,var3,var4,var5,var6,var7,var8,var9,var10 from UA#DailyReport where riqijiu like '"&sqlriqijiu.Value&"%' and shijianjiu between 16 and 23 order by shijianjiu"
select avg(var1),avg(var2),avg(var3),avg(var4),avg(var5),avg(var6),avg(var7),avg(var8),avg(var9),avg(var10) from UA#DailyReport where riqijiu like '"&sqlriqijiu.Value&"%' and shijianjiu between 16 and 23 "
然后是什么反应也没,打印预览的画面里面也是空的 只有原来的框架。请教高手怎么回事!!