在Access中，多表查询并去掉重复行，怎么得到记录数呢？用Count(DISTINCT 表名.列名)出错呢？

[OverIsOver]

//这是查询记录集，是对的
select DISTINCT TA.ID,TA.Dog, TA.LastRegTime,TA.DogType,TA.UserName
from TA,TB,RegInfo where TA.VendorID=1 and TA.DogGroupID=7 and ( (TA.ID=TB.DogID and TB.ID=RegInfo.ApplyID ) or (TA.LastRegTime is null) ) order by TA.ID desc

//可想直接查上面查询的记录行数，就出错呢？
select Count(DISTINCT TA.ID)
from TA,TB,RegInfo where TA.VendorID=1 and TA.DogGroupID=7 and ( (TA.ID=TB.DogID and TB.ID=RegInfo.ApplyID ) or (TA.LastRegTime is null) )

谢谢指点一二了~ 现在的笨方法是想查询记录集，再得到它的记录数，汗~~

[wwwwb]

select Count(TA.ID)
from TA,TB,RegInfo where TA.VendorID=1 and TA.DogGroupID=7 and ( (TA.ID=TB.DogID and TB.ID=RegInfo.ApplyID ) or (TA.LastRegTime is null) )

[OverIsOver]

楼上的不对哦，没有去除掉重复记录的；第一个查询记录集的记录行数是7，可按楼上的查询到的Count是28啊~

[OverIsOver]

再顶顶~

[wwwwb]

ACCESS不支持Count(DISTINCT TA.ID)格式，试试
select Count(*) from (select DISTINCT TA.ID,TA.Dog, TA.LastRegTime,TA.DogType,TA.UserName
from TA,TB,RegInfo where TA.VendorID=1 and TA.DogGroupID=7 and ( (TA.ID=TB.DogID and TB.ID=RegInfo.ApplyID ) or (TA.LastRegTime is null) ) order by TA.ID desc
) as ff

[OverIsOver]

哈哈，这样也就和我的方法一样了吧？好的，结贴了，谢谢你的关注:)