Skip to content

Query: SubQry Rpt Count Terminated Leads

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

Tables Referenced

  • SubQry Rpt Marketing Leads Criteria
  • SubQry

Columns Selected

  • [SubQry Rpt Marketing Leads Criteria].[Lead Type ID]
  • [SubQry Rpt Marketing Leads Criteria].[Lead Type]
  • Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID])

Where Clause

((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=41))

SQL

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=41))