count distinct in 1 query?

[Guest]

I would like to count distinct pol_no in the table. Is there a way to do
this without creating 2 queries (the first will group by pol_no and source
ID, the second will count the pol_no by source id)

Any help would be appreciated! Thanks!

SELECT PS_OWNER_GECNSR3_POL_AGT.SOURCE_SYS_ID,
Count(PS_OWNER_GECNSR3_POL_AGT.POL_NO) AS CountOfPOL_NO
FROM PS_OWNER_GECNSR3_POL_AGT
WHERE (((PS_OWNER_GECNSR3_POL_AGT.END_DATE)=#12/31/9999#))
GROUP BY PS_OWNER_GECNSR3_POL_AGT.SOURCE_SYS_ID;

 

[[MVP] S.Clark]

You might be able to with a subquery.

http://www.mvps.org/access/queries/qry0020.htm