一个SQL语句问题，高手请进

[popety_bit]

语句：cn.Execute "select 姓名, sum(迟到) as 迟到次数 from tbl_break 就是执行不过去，出错信息如下：
试图执行的查询中不包含作为合计函数一部分的的特定表达式'姓名'，而'姓名'字段的确存在。
请教各位高手，这是什么原因，如何改？

[acev]

加个[]号呢？
cn.Execute "select [姓名], sum([迟到]) as [迟到次数] from tbl_break"

[Yang_]

select 姓名, sum(迟到) as 迟到次数 from tbl_break Group by 姓名

[sunssc]

select [姓名], sum(迟到) as 迟到次数 from tbl_break Group by 姓名