Query: Qry SubRpt Unqualified Reasons Marketing by Principal Project

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

Tables Referenced

• vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject

Columns Selected

• vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject.[Unqualified Reason]
• Count(vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject.[Entrepreneur

Where Clause

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

SQL

SELECT vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject.[Unqualified Reason], Count(vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject.[Entrepreneur  FROM [vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi