Skip to content

Query: Qry SubRpt Termination Reasons Marketing by Principal Project

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

Tables Referenced

  • vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject

Columns Selected

  • vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject.[Termination Reason]
  • Count(vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject.[Entrepreneur I

Where Clause

(((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi

SQL

SELECT vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject.[Termination Reason], Count(vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject.[Entrepreneur I FROM [vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi