Skip to content

Query: Qry Report Lead Daily Breakdown

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

Tables Referenced

  • SubQry Rpt Lead Daily Breakdown Count Total Leads
  • SubQry Rpt Lead Daily Breakdown Count Passed Panel Leads
  • SubQry
  • SubQry Rpt Lead Daily Breakdown Count Qualified Leads

Columns Selected

  • [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Date Record Created]
  • [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Lead Type]
  • [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Total Leads Generated]
  • IIf(IsNull([Qualified Leads]),0,[Qualified Leads])
  • IIf(IsNull([Passed Panel Leads]),0,[Passed Panel Leads])

SQL

SELECT [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Date Record Created], [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Lead Type], [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Total Leads Generated], IIf(IsNull([Qualified Leads]),0,[Qualified Leads]), IIf(IsNull([Passed Panel Leads]),0,[Passed Panel Leads]) FROM [SubQry Rpt Lead Daily Breakdown Count Passed Panel Leads], [SubQry Rpt Lead Daily Breakdown Count Qualified Leads], [SubQry Rpt Lead Daily Breakdown Count Total Leads]