MsAccess bug? or query wrong?
Posted on 2006-06-14
Performing a query, I need a sum of counts of tables.
SELECT DISTINCT ( SELECT COUNT ([CSTLINKMEMBERS1])
The subquery DOES return "0": SELECT COUNT ([CSTLINKMEMBERS1]) FROM CSTLINKMEMBERSCHECKED WHERE ((CSTLINKMEMBERS1)=0).
I would expect this to return "0", would you not?
However it returns no rows at all! its frustrating!
Note: there are times I need to test over 18 fields, so the following query will not work, because of the annoying "Query is too Complex" (one table per field).
SELECT COUNT ([a.CSTLINKMEMBERS1]) AS PASSED1,
(SELECT CSTLINKMEMBERS1 FROM CSTLINKMEMBERSCHECKED WHERE CSTLINKMEMBERS1=0) a,