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!

Register Log in
  • Congratulations SkipVought 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: *

  1. MikeBinKC

    Help with Min()/Grouping

    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?
  2. MikeBinKC

    Help with Min()/Grouping

    Chamilz, I got the result I was looking for; thank you. This is a technique I'm not familiar with. Can you explain the join? MIke
  3. MikeBinKC

    Help with Min()/Grouping

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

    Help with Min()/Grouping

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

Part and Inventory Search

Back
Top