Skip to content

Query: SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc

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].[Company Delivery Location
  • [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].[Delivery Location]

SQL

SELECT [SubQry Rpt Opal Principal Project Summary Criteria].[Company Delivery Location , [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]