Skip to content

Query: SubQry Rpt Average Days Per Step Sum Days

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

Tables Referenced

  • SubQry
  • SubQry Rpt Average Days Per Step

Columns Selected

  • [SubQry Rpt Average Days Per Step].[Delivery Location ID]
  • [SubQry Rpt Average Days Per Step].[Delivery Location]
  • OwnedBy
  • Sum([SubQry Rpt Average Days Per Step].[Step 1-2 Days])
  • Sum([SubQry Rpt Average Days Per Step].[Step 2-3 Days])
  • Sum([SubQry Rpt Average Days Per Step].[Step 3-4 Days])
  • Sum([SubQry Rpt Average Days Per Step].[Step 4-5 Days])
  • Sum([SubQry Rpt Average Days Per Step].[Step 5-6 Days])
  • Sum([SubQry Rpt Average Days Per Step].[Step 6-7 Days])
  • Sum([SubQry Rpt Average Days Per Step].[Step 7-8 Days])

SQL

SELECT [SubQry Rpt Average Days Per Step].[Delivery Location ID], [SubQry Rpt Average Days Per Step].[Delivery Location], [SubQry Rpt Average Days Per Step].OwnedBy, Sum([SubQry Rpt Average Days Per Step].[Step 1-2 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 2-3 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 3-4 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 4-5 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 5-6 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 6-7 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 7-8 Days]) FROM [SubQry Rpt Average Days Per Step]