Help with Subquery



I am trying to compact some of the views we have in our DB, I am turning 2
views into one, with the use of a subquery. The problem I get is that this
view works fine but won't display any Nulls in the Success Column. The nulls
(converted into zero's) are required as I pass into a script. Not having
these would cause errors in the script etc.

I have a ISNULL in the appropriate field and the Left Outer Join on the
Targets table etc but can't quite figure what I'm missing.

There are two tables concerned here;
A table with the atrget infomation in, This table also includes area's where
no sales are required, and the Primary Key field is the SalesPersonCodeVM.

The second table is where my script writes all the infomation back, the
sales codes are AgBAP and AgHAP(LastCRC field), again the SalesPersonCodeVN
is referenced.

What I want is a view with the following Fields; SalespersonCodeVM,
SalesPersonName, Location, Target, Success...

SELECT cmp_HiddenHearingOverallTargets.SalesPersonCodeVM,
cmp_HiddenHearingOverallTargets.SalesPersonName,
cmp_HiddenHearingOverallTargets.Location,
cmp_HiddenHearingOverallTargets.Target,
COUNT(ISNULL(cmp_HiddenHearingOverall.LastCRC, 0))
AS Success
FROM cmp_HiddenHearingOverallTargets LEFT OUTER JOIN
cmp_HiddenHearingOverall ON
cmp_HiddenHearingOverallTargets.SalesPersonCodeVM =
cmp_HiddenHearingOverall.SalesPersonCodeVM
WHERE (cmp_HiddenHearingOverall.LastCRC = 'AgBAP') OR
(cmp_HiddenHearingOverall.LastCRC = 'AgHAP')
GROUP BY cmp_HiddenHearingOverallTargets.SalesPersonCodeVM,
cmp_HiddenHearingOverallTargets.Location,
cmp_HiddenHearingOverallTargets.SalesPersonName,
cmp_HiddenHearingOverallTargets.Target

Please help me figure this out as its really annoying me how close I am.
.