Yeah, ethorn 10...I tried to convince the sales manager to allow calls to only one number so the numbers would be right, but he wasn't buying it. LOL. Thanks for your help!
Now to study that join, as I've never used a join that way before. Any insight?
ethorn10,
That *almost* works; however it doesn't account for the fact that the lead might have more than one phone number that the employee could call. Notice that Grumpy was called twice, with different numbers. I don't care what number was called; I just want the earliest. Your query returns...
Hello, All.
I am developing some reports to be used with a company's phone call accounting and CRM systems. For discussion purposes, let me set this scenario: Each employee is assigned a number of leads, whom they are expected to call. They may call each lead a number of times. I want my...
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.