Totalling a SubTotal

[rdg0351]

I have a report that has Detail, Lvl1, LVl2 and Grand totals. The Detail field is "Vote=Y/N". I'm trying to create a field which is a total of a subtotal and NOT the total of the detail. For example,

Detail
A1 - Y
A2 - Y
B1 - Y
C1 - N

I want a result based on counts of "Y" vs "N" unique to the prefix. I'm making it easy since a vote for A1 is the same for A2, A3, A4, etc

Therefore the results would be:

Lvl1 - Y Lvl1 - N
2 1

Lvl2 is nothing more than Batches of Lvl 1's. I can get the Lvl1's correctly, but when I COUNT or SUM the value @ Lvl 1, I get the old "Enter Parameter Value" box. Can I do what I want?

 

[vbaInet]

How did you get 2 for Lvl1-Y count? I can see 3?!?

 

[rdg0351]

A1 & A2 are 2 separate records, but only count as a single vote. Therefore, the A's count as 1, the B's count as 1 and the C's are 0. I get confused over this as well

 

[vbaInet]

It wouldn't be difficult to do. But clarify this, is it going to be just one single alphabet followed by one or more digits?