Skip to content

Query: Qry Report Marketing Leads Version Two

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

Tables Referenced

  • SubQry Rpt Count Uncontacted Leads
  • SubQry Rpt Count Unqualified Leads
  • SubQry Rpt Count Followed Up Leads
  • SubQry Rpt Count Terminated Leads
  • SubQry Rpt Count On Hold 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([Unqualified Leads]),0,[Unqualified Leads])
  • IIf(IsNull([Uncontacted Leads]),0,[Uncontacted Leads])
  • IIf(IsNull([To Be Followed Up Leads]),0,[To Be Followed Up Leads])
  • IIf(IsNull([Terminated Leads]),0,[Terminated Leads])
  • IIf(IsNull([On Hold Leads]),0,[On Hold 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([Unqualified Leads]),0,[Unqualified Leads]), IIf(IsNull([Uncontacted Leads]),0,[Uncontacted Leads]), IIf(IsNull([To Be Followed Up Leads]),0,[To Be Followed Up Leads]), IIf(IsNull([Terminated Leads]),0,[Terminated Leads]), IIf(IsNull([On Hold Leads]),0,[On Hold Leads]) FROM [SubQry Rpt Count Total Leads Generated], [SubQry Rpt Count Qualified Leads], [SubQry Rpt Count Unqualified Leads], [SubQry Rpt Count Uncontacted Leads], [SubQry Rpt Count Followed Up Leads], [SubQry Rpt Count Terminated Leads], [SubQry Rpt Count On Hold Leads]