SELECT TOP 1 1 as row, "Multimedia Equipped" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(Select qryMMtotalPCs.Count FROM qryMMtotalPCs WHERE qryMMtotalPCs.Type = "Computer Lab" AND qryMMtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab], 
(Select qryMMtotalPCs.Count FROM qryMMtotalPCs WHERE qryMMtotalPCs.Type = "PreK-2" AND qryMMtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2], 
(Select qryMMtotalPCs.Count FROM qryMMtotalPCs WHERE qryMMtotalPCs.Type = "3-5" AND qryMMtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5], 
(Select qryMMtotalPCs.Count FROM qryMMtotalPCs WHERE qryMMtotalPCs.Type = "6-8" AND qryMMtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8], 
(Select qryMMtotalPCs.Count FROM qryMMtotalPCs WHERE qryMMtotalPCs.Type = "9-12" AND qryMMtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12], 
(Select qryMMtotalPCs.Count FROM qryMMtotalPCs WHERE qryMMtotalPCs.Type = "ACC" AND qryMMtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS ACC, 
(Select qryMMtotalPCs.Count FROM qryMMtotalPCs WHERE qryMMtotalPCs.Type = "Library / Media Center" AND qryMMtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center], 
(Select qryMMtotalPCs.Count FROM qryMMtotalPCs WHERE qryMMtotalPCs.Type = "Administration Office" AND qryMMtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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 2 as row, "Internet Connected" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "Computer Lab" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];)+(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "Computer Lab" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "PreK-2" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];)+(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "PreK-2" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "3-5" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];)+(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "3-5" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "6-8" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];)+(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "6-8" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "9-12" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];)+(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "9-12" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "ACC" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];)+(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "ACC" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS ACC, 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "Library / Media Center" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];)+(select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "Library / Media Center" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "Administration Office" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];)+(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "Administration Office" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWiredtotalPCs;
UNION 
SELECT TOP 1 3 as row, "Wired Connection" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "Computer Lab" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "PreK-2" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "3-5" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "6-8" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "9-12" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "ACC" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS ACC, 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "Library / Media Center" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center], 
(Select qryWiredtotalPCs.Count FROM qryWiredtotalPCs WHERE qryWiredtotalPCs.Type = "Administration Office" AND qryWiredtotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWiredtotalPCs;
UNION 
SELECT TOP 1 4 as row, "     Desktop" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Desktop" AND qryWiredtotalPCtype.Location = "Computer Lab" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Desktop" AND qryWiredtotalPCtype.Location = "PreK-2" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Desktop" AND qryWiredtotalPCtype.Location = "3-5" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Desktop" AND qryWiredtotalPCtype.Location = "6-8" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Desktop" AND qryWiredtotalPCtype.Location = "9-12" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Desktop" AND qryWiredtotalPCtype.Location = "ACC" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [ACC],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Desktop" AND qryWiredtotalPCtype.Location = "Library / Media Center" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Desktop" AND qryWiredtotalPCtype.Location = "Administration Office" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWiredtotalPCtype;
UNION 
SELECT TOP 1 5 as row, "     Laptop" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Laptop" AND qryWiredtotalPCtype.Location = "Computer Lab" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Laptop" AND qryWiredtotalPCtype.Location = "PreK-2" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Laptop" AND qryWiredtotalPCtype.Location = "3-5" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Laptop" AND qryWiredtotalPCtype.Location = "6-8" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Laptop" AND qryWiredtotalPCtype.Location = "9-12" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Laptop" AND qryWiredtotalPCtype.Location = "ACC" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [ACC],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Laptop" AND qryWiredtotalPCtype.Location = "Library / Media Center" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Laptop" AND qryWiredtotalPCtype.Location = "Administration Office" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWiredtotalPCtype;
UNION 
SELECT TOP 1 6 as row, "     Handheld" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Handheld" AND qryWiredtotalPCtype.Location = "Computer Lab" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Handheld" AND qryWiredtotalPCtype.Location = "PreK-2" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Handheld" AND qryWiredtotalPCtype.Location = "3-5" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Handheld" AND qryWiredtotalPCtype.Location = "6-8" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Handheld" AND qryWiredtotalPCtype.Location = "9-12" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Handheld" AND qryWiredtotalPCtype.Location = "ACC" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [ACC],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Handheld" AND qryWiredtotalPCtype.Location = "Library / Media Center" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center],
(select qrywiredtotalPCtype.COunt FROM qrywiredtotalPCtype WHERE qryWiredtotalPCtype.type = "Handheld" AND qryWiredtotalPCtype.Location = "Administration Office" AND qryWiredtotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWiredtotalPCtype;
UNION 
SELECT TOP 1 7 as row, "Wireless Connection" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "Computer Lab" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab], 
(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "PreK-2" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2], 
(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "3-5" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5], 
(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "6-8" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8], 
(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "9-12" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12], 
(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "ACC" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS ACC, 
(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "Library / Media Center" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center], 
(Select qryWirelesstotalPCs.Count FROM qryWirelesstotalPCs WHERE qryWirelesstotalPCs.Type = "Administration Office" AND qryWirelesstotalPCs.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWirelesstotalPCs;
UNION 
SELECT TOP 1 8 as row, "     Desktop" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Desktop" AND qryWirelesstotalPCtype.Location = "Computer Lab" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Desktop" AND qryWirelesstotalPCtype.Location = "PreK-2" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Desktop" AND qryWirelesstotalPCtype.Location = "3-5" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Desktop" AND qryWirelesstotalPCtype.Location = "6-8" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Desktop" AND qryWirelesstotalPCtype.Location = "9-12" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Desktop" AND qryWirelesstotalPCtype.Location = "ACC" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [ACC],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Desktop" AND qryWirelesstotalPCtype.Location = "Library / Media Center" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Desktop" AND qryWirelesstotalPCtype.Location = "Administration Office" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWirelesstotalPCtype;
UNION 
SELECT TOP 1 9 as row, "     Laptop" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Laptop" AND qryWirelesstotalPCtype.Location = "Computer Lab" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Laptop" AND qryWirelesstotalPCtype.Location = "PreK-2" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Laptop" AND qryWirelesstotalPCtype.Location = "3-5" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Laptop" AND qryWirelesstotalPCtype.Location = "6-8" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Laptop" AND qryWirelesstotalPCtype.Location = "9-12" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Laptop" AND qryWirelesstotalPCtype.Location = "ACC" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [ACC],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Laptop" AND qryWirelesstotalPCtype.Location = "Library / Media Center" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Laptop" AND qryWirelesstotalPCtype.Location = "Administration Office" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWirelesstotalPCtype;
UNION 
SELECT TOP 1 10 as row, "     Handheld" as [Computer Type], Forms![BuildingSelector]![BuildingSelector] AS BuildingID, 
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Handheld" AND qryWirelesstotalPCtype.Location = "Computer Lab" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Computer Lab],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Handheld" AND qryWirelesstotalPCtype.Location = "PreK-2" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [PreK-2],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Handheld" AND qryWirelesstotalPCtype.Location = "3-5" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [3-5],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Handheld" AND qryWirelesstotalPCtype.Location = "6-8" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [6-8],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Handheld" AND qryWirelesstotalPCtype.Location = "9-12" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [9-12],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Handheld" AND qryWirelesstotalPCtype.Location = "ACC" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [ACC],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Handheld" AND qryWirelesstotalPCtype.Location = "Library / Media Center" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) AS [Library/Media Center],
(select qryWirelesstotalPCtype.COunt FROM qryWirelesstotalPCtype WHERE qryWirelesstotalPCtype.type = "Handheld" AND qryWirelesstotalPCtype.Location = "Administration Office" AND qryWirelesstotalPCtype.BuildingID=Forms![BuildingSelector]![BuildingSelector];) 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])
FROM qryWirelesstotalPCtype;