Count total occurrences in different fields

[iht]

Fairly new to Access and really doesn't know much about SQL except some basic commands. Currently I'm working with a database that I've already sorted by some queries, and here's a simplified result.

Query1:
Name A B
Smith_A Ya [null]
Smith_R Yb Ya
Smith_C [null] E
Smith_B E Y

So far I can count occurrences of "Y" in single fields by using

SELECT Count(*) AS NumA
FROM [Query1]
WHERE [Query1].A like 'Y*';
 

And get result:
NumA
2

What I want as final result is to tally up total number of names and total occurences of "Y" in the 2 fields, so the final query (or report) will show:

NumPersons NumA NumB
4 2 2

Writing single query for each field then report them together is really dirty since the original database has about 70 fields and 65 records. I just wonder if there's a more elegant way of doing it.

I suppose I can always export the query to Excel and use COUNTIF to do this, but I would like to know if there's a way to write the query so I can keep it all in Access without having to write formulas in reports.

Sorry for the newbie question and thanks in advance for the help.

[NeoPa]

SELECT Count([Name]) AS NumName,
   Sum(IIf([A] Like 'Y*',1,0)) AS NumA,
   Sum(IIf([b] Like 'Y*',1,0)) AS NumB
FROM [Query1];

PS. Someone that cares about the elegance of code doesn't ask newbie questions!