SELECT Count(IIf([YesNoField],1,Null)) AS Yes, Count(IIf([YesNoField],Null,1)) AS [No], "Table1" AS Expr1
FROM table1
GROUP BY "Table1"
UNION
SELECT Count(IIf([YesNoField],1,Null)) AS Yes, Count(IIf([YesNoField],Null,1)) AS [No], "Table2" AS Expr1
FROM table2
GROUP BY "Table2"
UNION
SELECT Count(IIf([YesNoField],1,Null)) AS Yes, Count(IIf([YesNoField],Null,1)) AS [No], "Table3" AS Expr1
FROM table3
GROUP BY "Table3"
UNION
SELECT Count(IIf([YesNoField],1,Null)) AS Yes, Count(IIf([YesNoField],Null,1)) AS [No], "Table4" AS Expr1
FROM table4
GROUP BY "Table4"
UNION SELECT Count(IIf([YesNoField],1,Null)) AS Yes, Count(IIf([YesNoField],Null,1)) AS [No], "Table5" AS Expr1
FROM table5
GROUP BY "Table5";