Skip to content

Query: SubQry Rpt Count Qualified Leads by Date

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].[Date Record Created]
  • Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID])

Where Clause

((([SubQry Rpt Marketing Leads Criteria].[Step Number])>=2 And ([SubQry Rpt Mark

SQL

SELECT [SubQry Rpt Marketing Leads Criteria].[Date Record Created], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Step Number])>=2 And ([SubQry Rpt Mark