1 Reply Latest reply on Jul 26, 2014 1:22 PM by erolst

    How to count the number of instances in a table report?

    slayden@msn.com

      I have a table of "leads" I need to report on....

       

      The leads are broken down into

      1. Lead Types
      2. Lead Sources

       

      I need to report on HOW many Current Client Referrals, Past Client Referals, Advertising Leads, etc. came in for a given time period

       

      What's the most efficient way to count how many of each would be in a table?

      Essentially looking for a SQL count function WHERE the field is LeadTypeID

       

      Thanks in advance for any help!

      Scott