Skip to content

Query: Qry SubRpt Unqualified Supplier List by Principal Project

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

Tables Referenced

  • vwPurpleSubRptUnqualifiedSupplierListbyPrincipalProject

Columns Selected

  • Count(vwPurpleSubRptUnqualifiedSupplierListbyPrincipalProject.[Entrepreneur ID])

Where Clause

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

SQL

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