help with a report from a calulated query

[JudyT]

Help please!

I have numerous queries that this report is based on but in particular I
want to add two calculated field together in the report area in a text box.

My queries are the first one
SELECT [Drill information].DrillType, [Drill information].Date, [Drill
information].Score, Count([Drill information].DrillType) AS CountOfDrillType
FROM [Drill information]
GROUP BY [Drill information].DrillType, [Drill information].Date, [Drill
information].Score
HAVING ((([Drill information].DrillType)<>"3" And ([Drill
information].DrillType)<>"4") AND (([Drill information].Date) Between
[forms]![Drill report review]![Beginning_Date] And [forms]![Drill report
review]![Ending_Date]) AND (([Drill information].Score)>=95));

Second one
SELECT DISTINCTROW Sum([Drills<>3-with Date Range].CountOfDrillType) AS [Sum
Of CountOfDrillType]
FROM [Drills<>3-with Date Range];


Third one:
SELECT Count([Drill information].DrillType) AS CountOfDrillType
FROM [Drill information]
GROUP BY [Drill information].DrillType, [Drill information].Date, [Drill
information].Score
HAVING ((([Drill information].DrillType)="3") AND (([Drill
information].Date) Between [forms]![Drill report review]![Beginning_Date] And
[forms]![Drill report review]![Ending_Date]) AND (([Drill
information].Score)>=95));


Fourth one
SELECT DISTINCTROW Sum([Drills_Info=3>=95-with date range
Count].CountOfDrillType) AS [Sum Of CountOfDrillType]
FROM [Drills_Info=3>=95-with date range Count];


Fith one tieing them together
SELECT [Drills<>3>=95-with Date Range-Sum].[Sum Of CountOfDrillType],
[Drills<>3>=95-with Date Range-Sum]![Sum Of CountOfDrillType]/[Drills<>3-with
Date Range-Sum]![Sum Of CountOfDrillType] AS [Percent], [Drills=3>=95-with
date range-Sum].[Sum Of CountOfDrillType], [Drills=3>=95-with date
range-Sum]![Sum Of CountOfDrillType]/[Drills=3-with Date Range-Sum]![Sum Of
CountOfDrillType] AS Percent10819c
FROM [Drills<>3>=95-with Date Range-Sum], [Drills<>3-with Date Range-Sum],
[Drills=3-with Date Range-Sum], [Drills=3>=95-with date range-Sum]
WITH OWNERACCESS OPTION;

however, in the report for this thing i want to add the sum of
Drills<>3>=95-with Date Range-Sum.Sum Of CountOfDrillType
and
Drills=3>=95-with date range-Sum.Sum Of CountOfDrillType

but for some reason when I do the build on these fields and do the
=[Drills<>3>=95-with Date Range-Sum.Sum Of
CountOfDrillType]+[Drills=3>=95-with date range-Sum.Sum Of CountOfDrillType]
no data shows up. I also did it where the query name [ ].[ ] was with
both of them and still no data shows up.

Can someone help me with this monstrasity.

Thank you in advance.