Search results for query: *

Thanks

Hey Ellifan I need to ask a HUGE favor. I need you to send me the database or just forward me the email i sent to you please if you can.

Sent the database.

My DB is too large to send any suggestions.

Well what do you need to see? So that I can show it to you?

No the size is fine. The thing is that I have 15 Agents, when it goes down the list it lists 9 on the first page and the rest on the second page. I want it to print all on one page.

It is set to None

Well the CountOfAgent is on another report not this one. On this report I only show the name of the lead and all the information that goes with the lead like, the date the lead called, lead's phone number, etc... I want the total number of leads to show up on the the textbox I created, txtCount...

The ABS(SUM[Leads.Agent]) is still giving me the error.

I am sorry I am fairly new to MS Access where would I find that property, because I do not see it in the text box properties.

It is still giving me the #Error.

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

Well it is giving me the #Error caption in the textbox. Well the report pulls each lead for a specific date range for a specfic agent, on the footer of the last page I put a textbox and labeled it txtNum I want it to show the total number of leads that the report will print. I am using the...

Thank You so much it worked. Can I bother anyone else for the second part about the report.

Will I want to count how many times each agent's name has appeared. See I give sales leads to my agents that sell homes. I want to be able to pull up a specific date range to see how many leads have been given to each. Another thing I am working on is that I have a query that pulls each lead...

This code is not pulling anything. All I get are the column names but no agent names nor any numbers. Please 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...