求一条sql语句,按月统计数据

[boy2002]

例如2003-10-19 8:01:30 60
2003-10-17 8:20:30 35
2003-9-8 3:9:10 43
2003-9-16 7:10:30 50

想要的结果
2003-10 95
2003-9 93
在access中如何写这个sql语句

[liuyann]

select format("yyyy-mm",datefiled),sum(valuefield)
from yourTable
group by format("yyyy-mm",datefiled)

[changechange]

select format("yyyy-mm",datefiled),sum(valuefield)
from yourTable
group by format("yyyy-mm",datefiled)

??????

可以运行？

select format(datefiled,"yyyy-mm"),sum(valuefield)
from yourTable
group by format(datefiled,"yyyy-mm")
还差不多

[boy2002]

还有其它方法吗