Well I was able to count the 1's and 2's but with them being grouped I get more then I want. I am looking for just counting the group once, not all the details. Is there a way to Distinct the Count like the way Crystal does?
Query the report record source, building two fields One and Two and populate them accordingly, that is, if a 1 stick a 1 in the One field, if a 2 stick a 1 in the Two field. Then group and sum.
