Skip to content

Query: Qry Report Marketing Leads

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

Tables Referenced

  • SubQry Rpt Count Exited Leads
  • SubQry Rpt Count Passed Panel Leads
  • SubQry
  • SubQry Rpt Count Qualified Leads
  • SubQry Rpt Count Total Leads Generated

Columns Selected

  • [SubQry Rpt Count Total Leads Generated].[Lead Type]
  • [SubQry Rpt Count Total Leads Generated].[Total Leads Generated]
  • IIf(IsNull([Qualified Leads]),0,[Qualified Leads])
  • IIf(IsNull([Passed Panel Leads]),0,[Passed Panel Leads])
  • IIf(IsNull([Exited Leads]),0,[Exited Leads])

SQL

SELECT [SubQry Rpt Count Total Leads Generated].[Lead Type], [SubQry Rpt Count Total Leads Generated].[Total Leads Generated], IIf(IsNull([Qualified Leads]),0,[Qualified Leads]), IIf(IsNull([Passed Panel Leads]),0,[Passed Panel Leads]), IIf(IsNull([Exited Leads]),0,[Exited Leads]) FROM [SubQry Rpt Count Total Leads Generated], [SubQry Rpt Count Qualified Leads], [SubQry Rpt Count Passed Panel Leads], [SubQry Rpt Count Exited Leads]