Thanks, but this doesn't do the job. I want to get all the information in the query and use the query for a report. If the subscriber is a single member, the count and the sum of members are equal so no problem. With the family plan, I count the number of plans and sum the number of members. I than add the family plan members and the ind. members to get a total membership. If there are no ind. members, I use the count and a zero is ok. With the family plans the zero is in the count, but the sum comes out a blank. When the member total is created in the query for the ind. and family totals I get a blank. I need a zero in the sum column if there are no members in the state for the family plan so I get a total for the total members, otherwise states with no family plans do not get the ind.plans counted, because the family is null(?)