Skip to content

Query: Qry Report Company Totals by Delivery Location

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

Tables Referenced

  • vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects

Columns Selected

  • vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Delivery Location]
  • vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Entrepreneur Compan
  • vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Company Name]
  • Sum(vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Allocated Amoun

Order By

vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Delivery Location], vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Company Name]

SQL

SELECT vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Delivery Location], vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Entrepreneur Compan, vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Company Name], Sum(vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects.[Allocated Amoun FROM [vwGarnetCurrentOnProgCompbyDeliveryLocwithPrincipalProjects]