Access 2003 query GroupBy and Count plus need total count

[RCinSTP]

I have a table with States MN and WI and each state lists how many Red apples and how many Green apples. The SQL below shows, for example, MN has 3 green and 4 red, and state WI has 3 green and 6 red. How can I see the total number of apples? 3 + 4 + 3 + 6 = 16 Can I show the total 16 in my query or do I need to use a Report? I could not figure out how to do this in either a Query or a Report. Thanks for your help.

SELECT apples.State, apples.AppleColor, Count(apples.AppleColor) AS CountOfAppleColor
FROM apples
GROUP BY apples.State, apples.AppleColor;

[JoeM]

You can use the DCOUNT function, i.e.

SELECT apples.State, apples.AppleColor, Count(apples.AppleColor) AS CountOfAppleColor, DCount("*","apples") AS TotalApples
FROM apples
GROUP BY apples.State, apples.AppleColor;

[RCinSTP]

Thank You! that worked perfect