Sub query question

[landslide]

I have am trying to write a subqueriy.I have three columns, Column A has a code like break, lunch the other two columns have a date and time. I am trying to do a sub query so I can group by column A times and count how many. Then do the same with column 2 in the same query. I can do it in seperate querys but not in a sub query or is thier an eaiers way here is my code.

SELECT Count(nettalley.STATE_CODE_1), Nettalley.STATE_CODE_1
FROM Nettalley
WHERE FormatDateTime([nettalley.STATE_TIME_1],4)="00:00"
GROUP BY Nettalley.STATE_CODE_1;

[Hack]

Would this work for you?

SELECT COUNT("COLA") AS COL_A_TOTAL, COUNT("COLB") AS COL_B_TOTAL
FROM tablename
WHERE 'whatever'
AND 'whatever_else'
GROUP BY COLA, COLB