By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Counting

P: 23
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.
Jun 29 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
Count() counts the number of records processed.

You need to design your query to return a record per agent if you want to count the agents.
Jun 29 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.