HVSummer:
but you don't need group query to know how much.
you can open that query in datasheet view then go to Home -> Records sub ribbon -> Totals -> click on that totals
You really should check what you say before posting it. Otherwise you give out mis-information that can confuse people and waste other experts' time having to contradict you publicly, which is usually to be avoided, but is necessary when you post stuff that's factually wrong. It wasn't necessary when you did it to me as my post was actually 100% correct.
In this case, you clearly
do need a GROUP BY query, just as I said in my earlier post. When you click on the Totals button on the ribbon that's exactly what you're doing - converting it into a GROUP BY query.
Again, please be very careful before posting, that you know what you're talking about to save time correcting you, and to save what must be humiliation when you're shown to be posting wrong information.