一条小语句 大得分

with msflex
strsql = "select count(distinct mdan) as a from cs_manager "
Set rct = ExecuteSql(strsql)
.Text = rct!a
end with

用行后 语句显示

操作符丢失在 count(distinct mdan) 中 可在查询分析器中运行正常怎么回师~~~

大哥帮我~~


[解决办法]


ACCESS中不支持count(distinct )

select count(mdan) as a from (select distinct mdan from cs_manager) a