>I have a cursor with AgentName, customer#'s, and policy#'s. I want to get a count of customers and a count of policies for each agent. The problem is I have only been able to count the total number of records in the cursor (policy#'s). Is there a way to increment customer#'s only when it changes? I do not want to do this in my query.

Craig, if you group your report by agent ID, put the fields with customer#'s and policy#'s in the reprt group footer, set option in Calculations for this field to Sum and Reset when agent ID field changes.

Nick