AnsweredAssumed Answered

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

Question asked by slayden@msn.com on Jul 26, 2014
Latest reply on Jul 26, 2014 by erolst

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

Outcomes