Skip to content

Query: Qry SubRpt Daily Lead Summary Raizcorp Possibles All Divs

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

Tables Referenced

  • vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs

Columns Selected

  • vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Distribution Model]
  • vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Delivery Location]
  • IIf(IsNull([Product ID]),IIf(IsNull([Recommended Product ID]),\
  • Count(vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Entrepreneur Compa

SQL

SELECT vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Distribution Model], vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Delivery Location], IIf(IsNull([Product ID]),IIf(IsNull([Recommended Product ID]),\, Count(vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Entrepreneur Compa FROM [vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs]