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 strongm 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: cattironheart
- Order by date
-
Report summing up contracts by agents
Yes that is what I am using to sort total team numbers: =Abs(Sum(Left([AgentID],1)="1")) This shows team total numbers. But how can I have it also add up all the different contracts for the team and individual agentIDs? Is the only way to show that with subreports? Do I need to have them all...- cattironheart
- Post #7
- Forum: Microsoft: Access Reports
-
Report summing up contracts by agents
Team 1 = 1A,1B,1C,1D,1E,1F Team 2 .. same as above and keeps going for the teams. The agents are the 1A,1B ...- cattironheart
- Post #5
- Forum: Microsoft: Access Reports
-
Report summing up contracts by agents
Duane, thank you for the welcome! Since I am not at work where the database resides I am going off of memory so I cant pound out the code from my head .. currently have a migraine which is not helping with that either! The table has these fields which I pull from a report in excel and then...- cattironheart
- Post #3
- Forum: Microsoft: Access Reports
-
Report summing up contracts by agents
I just started a new job as an office manager and am trying to use my self-taught access skills to use since they don’t want to hire a computer person. I have a table that tracks contracts made and by what AgentID completes them. What I require is a report that breaks the amount of contracts...- cattironheart
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
