Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ozzie1121
  • Content: Threads
  • Order by date
  1. Ozzie1121

    Report Question

    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...
  2. Ozzie1121

    My code is not working HELP

    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...

Part and Inventory Search

Back
Top