MSAccess: Select Distinct

Imam sledeci query

SELECT DISTINCT Count(solverID) as Num FROM Topics WHERE IsSolved = True AND CID="&CID&" AND solverID <> 0 GROUP BY SolverID

Kad listam rezultate dobijam 3 iako imam samo 0, 1 i 2 u polju SolverID.

Zasto se ovo desava?

Odavno nisam radio nista sa bazama, ali probaj ovo:

SELECT COUNT(SELECT DISTINCT ....)

Potpis

Blue Man Group

zar nebi trebalo SELECT COUNT(DISTINCT nesto).... ?
nije isto SELECT COUNT(DISTINCT nesto) i SELECT DISTINCT COUNT(nesto)

Potpis

Goran Pilipović fka bluesman

Ne radi...

SELECT DISTINCT COUNT(Field) ti vraca broj razlicitih pojava polja Field