Here is my code. When I delete the HSFT data the AllPrograms Report
those not return any values. That is, this query for which I provide
the code below returns the values for this report. Thanks, John

SELECT qryTotalAge.*, qryTotalRace.*, qryTotalEmploy.*,
qryTotalEducation.*, qryTotalIncome.*, qryTotAgeOthNR.*,
qryTotEducOthNR.*, qryHSFTageEdu.[SumOfQ1 <=12 Years], qryHSFTageEdu.
[SumOfQ1 13 Years], qryHSFTageEdu.[SumOfQ1 14 Years] AS [SumOfQ1 14
Years HSFTageEdu], qryHSFTageEdu.[SumOfQ1 >=15 years], qryHSFTageEdu.
[SumOfQ1 Other], qryHSFTageEdu.[SumOfQ1 No Response], qryHSFTageEdu.
[SumOfQ2 <=12 Years], qryHSFTageEdu.[SumOfQ2 13 Years], qryHSFTageEdu.
[SumOfQ2 14 Years] AS [SumOfQ2 14 Years HSFTageEdu], qryHSFTageEdu.
[SumOfQ2 >=15 years], qryHSFTageEdu.[SumOfQ2 Other], qryHSFTageEdu.
[SumOfQ2 No Response], qryHSFTageEdu.[SumOfQ3 <=12 Years],
qryHSFTageEdu.[SumOfQ3 13 Years], qryHSFTageEdu.[SumOfQ3 14 Years] AS
[SumOfQ3 14 Years HSFTageEdu], qryHSFTageEdu.[SumOfQ3 >=15 years],
qryHSFTageEdu.[SumOfQ3 Other1], qryHSFTageEdu.[SumOfQ3 No Response],
qryHSFTageEdu.[SumOfQ4 <=12 Years], qryHSFTageEdu.[SumOfQ4 13 Years],
qryHSFTageEdu.[SumOfQ4 14 Years] AS [SumOfQ4 14 Years HSFTageEdu],
qryHSFTageEdu.[SumOfQ4 >=15 years], qryHSFTageEdu.[SumOfQ4 Other1],
qryHSFTageEdu.[SumOfQ4 No Response], qryHSFTageEdu.[SumOfQ1 <=8th
Grade], qryHeartSmartForTeens.[SumOfQ1 <=8th Grade] AS [Q1 <=8th
Grade1], qryHSFTageEdu.[SumOfQ1 9th-12th Grade], qryHeartSmartForTeens.
[SumOfQ1 9th-12th Grade] AS [Q1 9th-12th Grade1], qryHSFTageEdu.
[SumOfQ1 Other1], qryHSFTageEdu.[SumOfQ1 No Response1], qryHSFTageEdu.
[SumOfQ2 <=8th Grade], qryHeartSmartForTeens.[SumOfQ2 <=8th Grade] AS
[Q2 <=8th Grade1], qryHSFTageEdu.[SumOfQ2 9th-12th Grade],
qryHeartSmartForTeens.[SumOfQ2 9th-12th Grade] AS [Q2 9th-12th
Grade1], qryHSFTageEdu.[SumOfQ2 Other1], qryHSFTageEdu.[SumOfQ2 No
Response1], qryHSFTageEdu.[SumOfQ3 <=8th Grade], qryHeartSmartForTeens.
[SumOfQ3 <=8th Grade] AS [Q3 <=8th Grade1], qryHSFTageEdu.[SumOfQ3
9th-12th Grade], qryHeartSmartForTeens.[SumOfQ3 9th-12th Grade] AS [Q3
9th-12th Grade1], qryHSFTageEdu.[SumOfQ3 Other], qryHSFTageEdu.
[SumOfQ3 No Response1], qryHSFTageEdu.[SumOfQ4 <=8th Grade],
qryHeartSmartForTeens.[SumOfQ4 <=8th Grade] AS [Q4 <=8th Grade1],
qryHSFTageEdu.[SumOfQ4 9th-12th Grade], qryHeartSmartForTeens.[SumOfQ4
9th-12th Grade] AS [Q4 9th-12th Grade1], qryHSFTageEdu.[SumOfQ4 No
Response1], qryTotalEthnicity.*
FROM qryTotalAge, qryTotalEmploy, qryTotalIncome, qryTotalRace,
qryTotAgeOthNR, qryTotEducOthNR, qryHSFTageEdu, qryTotalEthnicity,
qryTotalEducation, qryHeartSmartForTeens;