Skip to content

Query: Qry Report Opal Prin Proj Summary Weighted Companies

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

Tables Referenced

  • SubQry Rpt Opal Principal Project Summary Criteria
  • SubQry

Columns Selected

  • [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project ID]
  • [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project]
  • [SubQry Rpt Opal Principal Project Summary Criteria].[Delivery Location]
  • Count([SubQry Rpt Opal Principal Project Summary Criteria].[Entrepreneur Company
  • Sum([SubQry Rpt Opal Principal Project Summary Criteria].[Allocated Weight])

Order By

[SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project], [SubQry Rpt Opal Principal Project Summary Criteria].[Delivery Location]

SQL

SELECT [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project ID], [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project], [SubQry Rpt Opal Principal Project Summary Criteria].[Delivery Location], Count([SubQry Rpt Opal Principal Project Summary Criteria].[Entrepreneur Company, Sum([SubQry Rpt Opal Principal Project Summary Criteria].[Allocated Weight]) FROM [SubQry Rpt Opal Principal Project Summary Criteria]