Counting Conditionally Groups

[RobNauticus]

Hello again,
CR10 & Access 2003


I want use a conditional group count in my report for several formulas but I am having issues creating the running total field that will count only the instances of a group not the actual records themselves.

I want to get a count of the groups (GP3) within (GP2) only counting the ones that are marked with the field {Company_Division.yn_Lennar}=true

I am able to create an overall count of the groups using a running total but I need a count exactly like the overall one excluding the groups that are not marked at true for the field mentioned above.

I am not sure how to structure the evaluate formula in the running total.

Please help!
Thanks,
Rob

 

[lbass]

Does the true condition appear in every record of the group to which it applies? If so, your running total evaluation formula could be:

(
onfirstrecord or
{table.group3field} <> previous({table.group3field})
) and
{Company_Division.yn_Lennar}=true

-LB