Source = "select * from DP1_EPM101 where ( DP1_EPM101.VA = (Select Max(VA) As Max from DP1_EPM101 where (DP1_EPM101.ADate Between #" & CheckDate & "# And #" & CheckDate1 & "#) group by day(DP1_EPM101.ADate))) "没验证,试试
调试欢乐多
select ADate,Max(va) From DP!_EPM01 Where ADate Between #' & checkdate & "'# And #'& Checkdate1 & "'# Group by ADAte"
对日期进行分组就好了
Source = "select * from DP1_EPM101 where ( DP1_EPM101.VA in(Select Max(VA) As Max from DP1_EPM101 where (DP1_EPM101.ADate Between #" & CheckDate & "# And #" & CheckDate1 & "#) Group by
DP1_EPM101.ADate ))
感觉阿飞的in用的正确,但
(Select Max(VA) As Max from DP1_EPM101 where (DP1_EPM101.ADate Between #" & CheckDate & "# And #" & CheckDate1 & "#) Group by
DP1_EPM101.ADate )这个子句只会出来一项又如何IN?结果恐怕只会有一项吧!
子句若只出来一项,说明只有1天。
IN里哪怕什么都没有也不影响查询的正确性。只说明连一条记录也没有。Source = "select * from DP1_EPM101 where ( DP1_EPM101.VA in (Select Max(VA) As Max from DP1_EPM101 where (DP1_EPM101.ADate Between #" & CheckDate & "# And #" & CheckDate1 & "#) group by day(DP1_EPM101.ADate))) "
我最后试了一下,我看“ roberthanker(冬天) ”和“echeng192(阿飞)”都比较的准确,谢谢!其他都对俺有帮助拉! !开始结分拉!呵呵!