Gord Dibben <gorddibbATshawDOTca wrote...
But OP wants the count to be 2 so he must have some kinda rule
that is not clear to the responders.............or himself<g
....

It's clear to the OP. He just expressed it poorly. At least to me it
looks like he wants something like (in Access 2003's @#$% SQL).


SELECT Count(*) AS ND_p
FROM (
SELECT T.p
FROM (
SELECT T1.p, Count(T1.f) AS nf, Count(T2.p) AS np
FROM [OP's Table] T1 INNER JOIN [OP's Table] T2 ON (T1.a=T2.a)
GROUP BY T1.a, T1.p
HAVING ((T1.a)='001')
) T
WHERE (T.nf=T.np)
);


Not something easily expressed in prose. Note: field names in SQL
above match OP's columns.