That depends on your relationship between CPEPARTNO and NCRNO. If it is a one-to-one relationship, adding it in like this should be fine:
Code:
SELECT
NCRFORM.NCRNO,
NCRFORM.CPEPARTNO,
COUNT(NCRFORM.CPEPARTNO)
FROM
NCRFORM
WHERE
NCRFORM.Date Between [Forms]![Non Conf Reports (Switchboard page)]![Combo91] And [Forms]![Non Conf Reports (Switchboard page)]![Combo93]
GROUP BY
NCRFORM.NCRNO,
NCRFORM.CPEPARTNO
HAVING
COUNT(NCRFORM.CPEPARTNO)>2;
If it is not a one-to-one relationship, it may break down your counts into more subcatergories that you do not want.
If that is the case, how do you decide which value of NCRNO you want to return, since there can be multiple NCRNO values for each CPEPARTNO value?