count函数
请教：统计 <表1> 中 'A '字段中非空行的个数，请给个完整的语句。

[解决办法]
select count(a) from tb1 where a is not null
[解决办法]
最好加上‘’情

Select Count(A) From 表1 Where A Is Not Null And A != ' '
[解决办法]
Dim Q As Integer '这个在这个问题中没用
rs.Open "select count(A) as Q from 表1 Where A Is Not Null ", .....
MsgBox rs!Q