>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
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison