access 通过union以天为单位统计当天的每个时段的数据(24H)

select * from

 (

select format( iif(isnull(min(real_date)), '2011-11-07 00:00:01', min(real_date)) , 'yyyymmdd hh') as mindate,

 iif(isnull(sum(dust)), 0, sum(dust)) as sumdust, iif(isnull(sum(dustex)), 0, sum(dustex)) as sumdustex, 

iif(isnull(sum(dust_flow)), 0, sum(dust_flow)) as sumdust_flow 

from t_real 

where real_date between #2011-11-07 00:00:01# and #2011-11-07 00:59:59#

union

select format( iif(isnull(min(real_date)), '2011-11-07 01:00:01', min(real_date)) , 'yyyymmdd hh') as mindate,

 iif(isnull(sum(dust)), 0, sum(dust)) as sumdust, iif(isnull(sum(dustex)), 0, sum(dustex)) as sumdustex, 

iif(isnull(sum(dust_flow)), 0, sum(dust_flow)) as sumdust_flow 

from t_real 

where real_date between #2011-11-07 01:00:01# and #2011-11-07 01:59:59#

) 

order by mindate