Skip to content

Query: Qry Report Average Days Per Step

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

Tables Referenced

  • SubQry
  • SubQry Rpt Average Days Per Step Sum Days
  • SubQry Rpt Average Days Per Step Get DL and Owner
  • SubQry Rpt Average Days Per Step Count EPs

Columns Selected

  • [SubQry Rpt Average Days Per Step Get DL and Owner].[Delivery Location ID]
  • [SubQry Rpt Average Days Per Step Get DL and Owner].[Delivery Location]
  • OwnedBy
  • IIf([EPs Step 1-2]=0,0,[Days Step 1-2]/[EPs Step 1-2])
  • IIf([EPs Step 2-3]=0,0,[Days Step 2-3]/[EPs Step 2-3])
  • IIf([EPs Step 3-4]=0,0,[Days Step 3-4]/[EPs Step 3-4])
  • IIf([EPs Step 4-5]=0,0,[Days Step 4-5]/[EPs Step 4-5])
  • IIf([EPs Step 5-6]=0,0,[Days Step 5-6]/[EPs Step 5-6])
  • IIf([EPs Step 6-7]=0,0,[Days Step 6-7]/[EPs Step 6-7])
  • IIf([EPs Step 7-8]=0,0,[Days Step 7-8]/[EPs Step 7-8])

SQL

SELECT [SubQry Rpt Average Days Per Step Get DL and Owner].[Delivery Location ID], [SubQry Rpt Average Days Per Step Get DL and Owner].[Delivery Location], [SubQry Rpt Average Days Per Step Get DL and Owner].OwnedBy, IIf([EPs Step 1-2]=0,0,[Days Step 1-2]/[EPs Step 1-2]), IIf([EPs Step 2-3]=0,0,[Days Step 2-3]/[EPs Step 2-3]), IIf([EPs Step 3-4]=0,0,[Days Step 3-4]/[EPs Step 3-4]), IIf([EPs Step 4-5]=0,0,[Days Step 4-5]/[EPs Step 4-5]), IIf([EPs Step 5-6]=0,0,[Days Step 5-6]/[EPs Step 5-6]), IIf([EPs Step 6-7]=0,0,[Days Step 6-7]/[EPs Step 6-7]), IIf([EPs Step 7-8]=0,0,[Days Step 7-8]/[EPs Step 7-8]) FROM [SubQry Rpt Average Days Per Step Get DL and Owner], [SubQry Rpt Average Days Per Step Sum Days], [SubQry Rpt Average Days Per Step Count EPs]