Skip to content

Query: Qry Report Marketing Leads by Date

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

Tables Referenced

  • SubQry Rpt Count Total Leads Generated by Date
  • SubQry
  • SubQry Rpt Count Qualified Leads by Date

Columns Selected

  • [SubQry Rpt Count Total Leads Generated by Date].[Date Record Created]
  • [SubQry Rpt Count Total Leads Generated by Date].[Total Leads Generated]
  • IIf(IsNull([Qualified Leads]),0,[Qualified Leads])

SQL

SELECT [SubQry Rpt Count Total Leads Generated by Date].[Date Record Created], [SubQry Rpt Count Total Leads Generated by Date].[Total Leads Generated], IIf(IsNull([Qualified Leads]),0,[Qualified Leads]) FROM [SubQry Rpt Count Total Leads Generated by Date], [SubQry Rpt Count Qualified Leads by Date]