On my report I only have two columns Agent and CountOfAgent. I have only 20 agents. When I print the report it shows the two columns. The thing is that on the 1st page it shows Agents 1 15 on page 2 it shows the rest. I would like to get the agents from page two to show up on page one so that I...
I am trying to count the number of records for each agent in my table per date range. Example:
5/1/04 - 5/8/04
Agent Records
John 2
Mary 21
Charlie 10
My Code looks like this:
SELECT Leads.Agent, Count(Leads.Agent) AS CountOfAgent
FROM Leads
GROUP BY Leads.Agent
HAVING...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.