Skip to content

Query: SubQry Rpt Average Days Per Step Count EPs

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
  • Count([SubQry Rpt Average Days Per Step].[Step 1-2 Days])
  • Count([SubQry Rpt Average Days Per Step].[Step 2-3 Days])
  • Count([SubQry Rpt Average Days Per Step].[Step 3-4 Days])
  • Count([SubQry Rpt Average Days Per Step].[Step 4-5 Days])
  • Count([SubQry Rpt Average Days Per Step].[Step 5-6 Days])
  • Count([SubQry Rpt Average Days Per Step].[Step 6-7 Days])
  • Count([SubQry Rpt Average Days Per Step].[Step 7-8 Days])

Order By

[SubQry Rpt Average Days Per Step].[Delivery Location], [SubQry Rpt Average Days Per Step].OwnedBy

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, Count([SubQry Rpt Average Days Per Step].[Step 1-2 Days]), Count([SubQry Rpt Average Days Per Step].[Step 2-3 Days]), Count([SubQry Rpt Average Days Per Step].[Step 3-4 Days]), Count([SubQry Rpt Average Days Per Step].[Step 4-5 Days]), Count([SubQry Rpt Average Days Per Step].[Step 5-6 Days]), Count([SubQry Rpt Average Days Per Step].[Step 6-7 Days]), Count([SubQry Rpt Average Days Per Step].[Step 7-8 Days]) FROM [SubQry Rpt Average Days Per Step]