Query: Qry SubRpt Unqualified Reasons Supplier Lst by Principal Project

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

Tables Referenced

• vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj

Columns Selected

• vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj.[Unqualified Reason]
• Count(vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj.[Entrepreneur ID])

Where Clause

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

SQL

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