Skip to content

Query: SubQry Count Progress Category RM by Principal Project Criteria

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

Tables Referenced

  • vwPurpleCountProgressCategoryRMbyPrinProjCriteria

Columns Selected

  • vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Entrepreneur ID]
  • vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Date Record Created]
  • vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Lead Source]
  • vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Company Name]
  • IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal
  • vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Progress Category]
  • vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Progress Category Sort]
  • IIf(IsNull([Company Status]),[Process Status],[Company Status])
  • IIf(IsNull([Company Status]),[Progress Category],[Company Status])
  • IIf(IsNull([Company Status Sort]),[Progress Category Sort],[Company Status Sort]

Where Clause

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

SQL

SELECT vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Entrepreneur ID], vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Date Record Created], vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Lead Source], vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Company Name], IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal, vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Progress Category], vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Progress Category Sort], IIf(IsNull([Company Status]),[Process Status],[Company Status]), IIf(IsNull([Company Status]),[Progress Category],[Company Status]), IIf(IsNull([Company Status Sort]),[Progress Category Sort],[Company Status Sort] FROM [vwPurpleCountProgressCategoryRMbyPrinProjCriteria] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi