Skip to content

Query: SubQry Rpt Lead Daily Breakdown Count Qualified Leads

Type: Select
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

  • SubQry Rpt Lead Daily Breakdown Criteria
  • SubQry

Columns Selected

  • [SubQry Rpt Lead Daily Breakdown Criteria].[Date Record Created]
  • [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type ID]
  • [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type]
  • Count([SubQry Rpt Lead Daily Breakdown Criteria].[Entrepreneur ID])

Where Clause

((([SubQry Rpt Lead Daily Breakdown Criteria].[Step Number])>=2 And ([SubQry Rpt

SQL

SELECT [SubQry Rpt Lead Daily Breakdown Criteria].[Date Record Created], [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type ID], [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type], Count([SubQry Rpt Lead Daily Breakdown Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Lead Daily Breakdown Criteria] WHERE ((([SubQry Rpt Lead Daily Breakdown Criteria].[Step Number])>=2 And ([SubQry Rpt