代码求助！！

[冰天天]

rs.Open "select * count(id) from saw where bd='" & a & "'", cn
我的意思是查询条件符合的记录，并统计id的个数，这样写对吗？

[-狙击手-]

rs.Open "select *,count(id) as s from saw where bd='" & a & "'", cn

[lzhs]

rs.Open "select *,count(id) as s from saw where bd='" & a & "'", cn
这样方法不对的！

推荐一个用法：
rs.Open "select *,count(１) as s from saw where bd='" & a & "'", cn

Count(id)取出的是所有符合Where后面条件的记录中id列不为NULL的记录总数．

[berwos]

count() 不是一个聚合函数么,如果是那么后面要有group by语句,要不调式的过去?