ado 问题！急！！！

[automation2008]

rsacount.Open "select × from table", conn

是查找全部的记录，但是 可以用 rsacount.Open "select acount() from table", conn,查找到有几条记录吗？怎么用这句语句呢？？或者其他方法的呢？？

[射天狼]

rsacount.Open "select count(*) as rows from table", conn

msgbox rsacount.Fields ("rows")

[huangjianyou]

select count(*) from table

[automation2008]

可以 把 select * from table
和 resacount.open "select count(*) from table" 写程一句话不？？
我时这样写的 rsacount.open "select count(*)as ll,name ,phone ,sex from talbe"
icount= rsacount.fields("ll")
其他的就写如msflexgrid 中但时没有一条数据呀！！

[混吃等死]

rs.open "select count(*) as Bm from table"

a=rs.fields!bm

[LichKingSZ]

select count(*) from table

[online]

rs.open "select count(*) as ll from table",conn,1,3
msgbox rs.fields("ll")

[warlord]

不能写成一句，COUNT是合计查询。