Skip to content

Query: Qry SubRpt Pipeline Process Status by Principal Project

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

Tables Referenced

  • SubQry
  • SubQry Count Process Status by Principal Project Criteria

Columns Selected

  • Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur
  • Status
  • [SubQry Count Process Status by Principal Project Criteria].[Sort Order]

Where Clause

((([SubQry Count Process Status by Principal Project Criteria].[Step Number])>=2

SQL

SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur , [SubQry Count Process Status by Principal Project Criteria].Status, [SubQry Count Process Status by Principal Project Criteria].[Sort Order] FROM [SubQry Count Process Status by Principal Project Criteria] WHERE ((([SubQry Count Process Status by Principal Project Criteria].[Step Number])>=2