Skip to content

Query: Qry Report Principal Project Totals by Delivery Location

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

Tables Referenced

  • vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects
  • SubQry
  • SubQry Rpt EP Counts by Principal Project Delivery Location

Columns Selected

  • vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Delivery Location]
  • vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Principal Project]
  • vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Total Spend]
  • [SubQry Rpt EP Counts by Principal Project Delivery Location].[Number of Entrepr
  • Sum(vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Allocated Amoun

SQL

SELECT vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Delivery Location], vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Principal Project], vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Total Spend], [SubQry Rpt EP Counts by Principal Project Delivery Location].[Number of Entrepr, Sum(vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Allocated Amoun FROM [SubQry Rpt EP Counts by Principal Project Delivery Location], [vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects]