Skip to content

Query: SubQry Count Progress Category SL by Principal Project Criteria

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

Tables Referenced

  • vwPurpleCountProgressCategorySLbyPrinProjCriteria

Columns Selected

  • vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Entrepreneur ID]
  • vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Date Record Created]
  • vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Lead Source]
  • vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Company Name]
  • IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal
  • IIf(IsNull([Company Status]),[Process Status],[Company Status])
  • vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Progress Category]
  • vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Progress Category Sort]
  • 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 vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Entrepreneur ID], vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Date Record Created], vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Lead Source], vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Company Name], IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal, IIf(IsNull([Company Status]),[Process Status],[Company Status]), vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Progress Category], vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Progress Category Sort], IIf(IsNull([Company Status]),[Progress Category],[Company Status]), IIf(IsNull([Company Status Sort]),[Progress Category Sort],[Company Status Sort] FROM [vwPurpleCountProgressCategorySLbyPrinProjCriteria] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi