Skip to content

Query: Qry SubRpt Termination Reasons Supplier Lst by Principal Project

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

Tables Referenced

  • vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj

Columns Selected

  • vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj.[Termination Reason]
  • Count(vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj.[Entrepreneur ID])

Where Clause

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

SQL

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