access 中如何实现用group得出日期中的年-月 ?
数据库中数据：
================================================================
id_dat_tit_
2122007-6-10Dance party at Sliver moon bar
2132007-6-15Dance party at Sliver moon bar
2142007-6-17Dance party at Sliver moon bar
2152007-6-22Dance party at Sliver moon bar
2162007-6-28Dance party at Sliver moon bar
2172007-6-30Dance party at Sliver moon bar
2182007-7-1Dance party at Sliver moon bar
2192007-7-5Dance party at Sliver moon bar
2202007-7-7Dance party at Sliver moon bar
2212007-7-13Dance party at Sliver moon bar
2222007-7-18Dance party at Sliver moon bar
2232007-7-27Dance party at Sliver moon bar
2242007-7-10Dance party at Sliver moon bar
2252007-8-15Dance party at Sliver moon bar
2262007-8-17Dance party at Sliver moon bar
2272007-8-22Dance party at Sliver moon bar
2282007-8-28Dance party at Sliver moon bar
2292007-8-30Dance party at Sliver moon bar
2302007-9-1Dance party at Sliver moon bar
2312007-9-5Dance party at Sliver moon bar
2322007-9-7Dance party at Sliver moon bar
2332007-9-13Dance party at Sliver moon bar
2342007-9-18Dance party at Sliver moon bar
2352007-9-27Dance party at Sliver moon bar
2362007-10-12Dance party at Sliver moon bar
2372007-10-22Dance party at Sliver moon bar
=====================================================================
想得到结果：
2007-6
2007-7
2007-8
2007-9
2007-10
现在SQL语句：
sql_ = " select dat_ from [blog_] group by dat_ order by dat_ desc "
得到的是每一天的group，我是access+asp，请高手帮助！
[解决办法]
sql_ = "
select format(dat_, 'yyyy-mm ')
from [blog_]
group by format(dat_, 'yyyy-mm ')
order by format(dat_, 'yyyy-mm ') desc "
