Output of Crosstab Query

[Dave Oakley]

I am updating a database(Access 97) which has several
crosstab queries which use a COUNT as the VALUE.
Previously, if the count was zero for any value, the
result was left blank. After making a change to the
query, I now get a zero for these cases. I can't find a
way to switch back to a blank output, even though this
would be better.

Here is the SQL I used for the crosstab query:

TRANSFORM Count(dbo_ccCalls.callID) AS [The Value]
SELECT AugRegCnty.region, AugRegCnty.county, Count
(dbo_ccCalls.callID) AS
[Total of callID]
FROM dbo_ccCalls RIGHT JOIN AugRegCnty ON
(AugRegCnty.County =
dbo_ccCalls.County) AND (AugRegCnty.Region =
dbo_ccCalls.Region) AND
(AugRegCnty.dateIn = dbo_ccCalls.dateIn)
GROUP BY AugRegCnty.region, AugRegCnty.county
PIVOT AugRegCnty.idDay;

This SQL generates a zero wherever the count is zero.
I would rather have
it leave a blank as it does on the other crosstabs in
this database. If you
can explain what causes the difference it would be a big
help! If you
need
any other info I can get that.

Thanks,
Dave Oakley