I am using Access 2010 and am just learning some of this. I have a report that is grouped by Agent with a header and footer for this group. I then list the calls an agent took. I put the agents name field in the header and am trying to count how many agents I have per report by putting =Count([txtAgentName]) in the Agent footer. When I run the report there is one agent name with 7 calls. The code in the footer shows 7. It should be 1. I only have 1 agent even though she made 7 calls. I thought doing this in the header and footer would only count it once not once for each call. Thanks in advance for the help.
Comment