SELECT TOP 1 1 as row, "Total Number of Rooms" as [Number of Rooms], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="Computer Lab"));) AS [Computer Lab], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="PreK-2"));) AS [PreK-2], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="3-5"));) AS [3-5], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="6-8"));) AS [6-8], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="9-12"));) AS [9-12], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="ACC"));) AS ACC, 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="Library / Media Center"));) AS [Library/Media Center], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="Administration Office"));) AS [Administration Office],
Nz([Computer Lab])+Nz([Prek-2])+Nz([3-5])+Nz([6-8])+Nz([9-12])+Nz([ACC])+Nz([Library/Media Center])+Nz([Administration Office]) AS Total
FROM Location;
UNION 
SELECT TOP 1 2 as row, "with telephone access" as [Number of Rooms], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="Computer Lab")) HAVING (((Location.Tel)<>0));) AS [Computer Lab], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="PreK-2")) HAVING (((Location.Tel)<>0));) AS [PreK-2], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="3-5")) HAVING (((Location.Tel)<>0));) AS [3-5], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="6-8")) HAVING (((Location.Tel)<>0));) AS [6-8], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="9-12")) HAVING (((Location.Tel)<>0));) AS [9-12], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="ACC")) HAVING (((Location.Tel)<>0));) AS ACC, 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="Library / Media Center")) HAVING (((Location.Tel)<>0));) AS [Library/Media Center], 
(SELECT Count(Location.RoomNumber) FROM Location WHERE (((Location.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((Location.Type)="Administration Office")) HAVING (((Location.Tel)<>0));) AS [Administration Office],
Nz([Computer Lab])+Nz([Prek-2])+Nz([3-5])+Nz([6-8])+Nz([9-12])+Nz([ACC])+Nz([Library/Media Center])+Nz([Administration Office]) AS Total
FROM Location;
UNION
SELECT TOP 1 3 as row, "with internet access
wired or wireless" as [Number of Rooms], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(SELECT Count(qryInternetEnabledRooms.RoomNumber) FROM qryInternetEnabledRooms WHERE (((qryInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryInternetEnabledRooms.Type)="Computer Lab"));) AS [Computer Lab], 
(SELECT Count(qryInternetEnabledRooms.RoomNumber) FROM qryInternetEnabledRooms WHERE (((qryInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryInternetEnabledRooms.Type)="PreK-2"));) AS [PreK-2], 
(SELECT Count(qryInternetEnabledRooms.RoomNumber) FROM qryInternetEnabledRooms WHERE (((qryInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryInternetEnabledRooms.Type)="3-5"));) AS [3-5], 
(SELECT Count(qryInternetEnabledRooms.RoomNumber) FROM qryInternetEnabledRooms WHERE (((qryInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryInternetEnabledRooms.Type)="6-8"));) AS [6-8], 
(SELECT Count(qryInternetEnabledRooms.RoomNumber) FROM qryInternetEnabledRooms WHERE (((qryInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryInternetEnabledRooms.Type)="9-12"));) AS [9-12], 
(SELECT Count(qryInternetEnabledRooms.RoomNumber) FROM qryInternetEnabledRooms WHERE (((qryInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryInternetEnabledRooms.Type)="ACC"));) AS ACC, 
(SELECT Count(qryInternetEnabledRooms.RoomNumber) FROM qryInternetEnabledRooms WHERE (((qryInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryInternetEnabledRooms.Type)="Library / Media Center"));) AS [Library/Media Center], 
(SELECT Count(qryInternetEnabledRooms.RoomNumber) FROM qryInternetEnabledRooms WHERE (((qryInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryInternetEnabledRooms.Type)="Administration Office"));) AS [Administration Office],
Nz([Computer Lab])+Nz([Prek-2])+Nz([3-5])+Nz([6-8])+Nz([9-12])+Nz([ACC])+Nz([Library/Media Center])+Nz([Administration Office]) AS Total
FROM qryInternetEnabledRooms;
UNION
SELECT TOP 1 4 as row, "with one or more multimedia equipped computers" as [Number of Rooms], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(SELECT Count(qryMMtotalPCs.RoomNumber) FROM qryMMtotalPCs WHERE (((qryMMtotalPCs.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMtotalPCs.Type)="Computer Lab"));) AS [Computer Lab], 
(SELECT Count(qryMMtotalPCs.RoomNumber) FROM qryMMtotalPCs WHERE (((qryMMtotalPCs.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMtotalPCs.Type)="PreK-2"));) AS [PreK-2], 
(SELECT Count(qryMMtotalPCs.RoomNumber) FROM qryMMtotalPCs WHERE (((qryMMtotalPCs.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMtotalPCs.Type)="3-5"));) AS [3-5], 
(SELECT Count(qryMMtotalPCs.RoomNumber) FROM qryMMtotalPCs WHERE (((qryMMtotalPCs.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMtotalPCs.Type)="6-8"));) AS [6-8], 
(SELECT Count(qryMMtotalPCs.RoomNumber) FROM qryMMtotalPCs WHERE (((qryMMtotalPCs.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMtotalPCs.Type)="9-12"));) AS [9-12], 
(SELECT Count(qryMMtotalPCs.RoomNumber) FROM qryMMtotalPCs WHERE (((qryMMtotalPCs.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMtotalPCs.Type)="ACC"));) AS ACC, 
(SELECT Count(qryMMtotalPCs.RoomNumber) FROM qryMMtotalPCs WHERE (((qryMMtotalPCs.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMtotalPCs.Type)="Library / Media Center"));) AS [Library/Media Center], 
(SELECT Count(qryMMtotalPCs.RoomNumber) FROM qryMMtotalPCs WHERE (((qryMMtotalPCs.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMtotalPCs.Type)="Administration Office"));) AS [Administration Office],
Nz([Computer Lab])+Nz([Prek-2])+Nz([3-5])+Nz([6-8])+Nz([9-12])+Nz([ACC])+Nz([Library/Media Center])+Nz([Administration Office]) AS Total
FROM qryMMtotalPCs;
UNION SELECT TOP 1 5 as row, "with one or more multimedia equipped computers connected to the Internet" as [Number of Rooms], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(SELECT Count(qryMMInternetEnabledRooms.RoomNumber) FROM qryMMInternetEnabledRooms WHERE (((qryMMInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMInternetEnabledRooms.Type)="Computer Lab"));) AS [Computer Lab], 
(SELECT Count(qryMMInternetEnabledRooms.RoomNumber) FROM qryMMInternetEnabledRooms WHERE (((qryMMInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMInternetEnabledRooms.Type)="PreK-2"));) AS [PreK-2], 
(SELECT Count(qryMMInternetEnabledRooms.RoomNumber) FROM qryMMInternetEnabledRooms WHERE (((qryMMInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMInternetEnabledRooms.Type)="3-5"));) AS [3-5], 
(SELECT Count(qryMMInternetEnabledRooms.RoomNumber) FROM qryMMInternetEnabledRooms WHERE (((qryMMInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMInternetEnabledRooms.Type)="6-8"));) AS [6-8], 
(SELECT Count(qryMMInternetEnabledRooms.RoomNumber) FROM qryMMInternetEnabledRooms WHERE (((qryMMInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMInternetEnabledRooms.Type)="9-12"));) AS [9-12], 
(SELECT Count(qryMMInternetEnabledRooms.RoomNumber) FROM qryMMInternetEnabledRooms WHERE (((qryMMInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMInternetEnabledRooms.Type)="ACC"));) AS ACC, 
(SELECT Count(qryMMInternetEnabledRooms.RoomNumber) FROM qryMMInternetEnabledRooms WHERE (((qryMMInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMInternetEnabledRooms.Type)="Library / Media Center"));) AS [Library/Media Center], 
(SELECT Count(qryMMInternetEnabledRooms.RoomNumber) FROM qryMMInternetEnabledRooms WHERE (((qryMMInternetEnabledRooms.BuildingID)=[Forms]![BuildingSelector]![BuildingSelector]) AND ((qryMMInternetEnabledRooms.Type)="Administration Office"));) AS [Administration Office],
Nz([Computer Lab])+Nz([Prek-2])+Nz([3-5])+Nz([6-8])+Nz([9-12])+Nz([ACC])+Nz([Library/Media Center])+Nz([Administration Office]) AS Total
FROM qryMMInternetEnabledRooms;