Query returning blank field okay!

[JudyT]

I have a query that is return a blank field on a count and that is okay
becuase there is no data thus far for this drill type. How do I make it show
zero in the query and then the report.

SELECT DISTINCTROW Count(*) AS [Count Of Drills_Info=4>=95]
FROM [Drills_Info=4>=95]
GROUP BY [Drills_Info=4>=95].CountOfDrillType;

The count of the Drill type is zero thus far.

In addition, I have another query that pulls this data into it. The fields
are calculations and they are returning the correct data but when i include
these fields it affects the other calculations to show zero. I am very
confused can you help?

The other query is this
SELECT [Drills_Info<>3>=95-Total-Count]![Count Of
Drills_Info<>3>=95]/[Drills_Info<>3-Total_Count]![Sum Of CountOfDrillType] AS
106_12, [Drills_Info=3>=95-Total_Count]![Count Of
Drills_Info=3>=95]/[Drills_Info=3-Total_Count]![Sum Of CountOfDrillType] AS
108_19_c
FROM [Drills_Info<>3>=95-Total-Count], [Drills_Info<>3-Total_Count],
[Drills_Info=3-Total_Count], [Drills_Info=3>=95-Total_Count]
WITH OWNERACCESS OPTION;