access按时间统计

access按时间统计

用format(mydate,"WW")就能返回日期是当年中的第几周，如：  
  select   format(mydate,"yyyy-ww")   as   YearWeek,   count(...),   sum(...)  
      from   ...  
    group   by   format(mydate,"yyyy-ww");