ACE Reports

[grinder332518]

I am writing a report for Access using ACE reports.
My final select looks like this :-

Select A, B, count(*) as countx from {temp table}
Group by A, B
Order by A, B

The rows look like :

A1 b1 14
A1 b2 7
B1 b3 8
B1 b4 4
B1 b5 3
etc etc

I would like the display below :
A1 b1 14
A1 b2 7
****** 21
B1 b3 8
B1 b4 4
B1 b5 3
***** 15
Total 36

So I would like a count of the sum of b column, as per **** above. (21 & 15).
I get the 36 count OK by including “total of countx” in the “on last row” section.
But what is the syntax for the group count in the “after group of a” section ?
I tried adding a variable “ws”, setting it to value “a” in the “before group of a” section, and coding “total of countx where ws = a” in the “after group of a” section, but a got a null return.
Many thanks is anticipation : I am new to this product !!