Skip to content

Query: Qry Report Average Time Through Pipeline by Distribution Model

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

Tables Referenced

  • SubQry
  • MonthLkUp
  • SubQry Rpt Average Time Through Pipeline Criteria

Columns Selected

  • [SubQry Rpt Average Time Through Pipeline Criteria].[Distribution Model]
  • Pipeline
  • DateSerial([TheYear],[TheMonth],1)
  • [Month Name] & \
  • Count([SubQry Rpt Average Time Through Pipeline Criteria].[Entrepreneur ID])
  • Sum([SubQry Rpt Average Time Through Pipeline Criteria].[Pipeline Days])

Order By

[SubQry Rpt Average Time Through Pipeline Criteria].[Distribution Model], [SubQry Rpt Average Time Through Pipeline Criteria].Pipeline, DateSerial([TheYear],[TheMonth],1)

SQL

SELECT [SubQry Rpt Average Time Through Pipeline Criteria].[Distribution Model], [SubQry Rpt Average Time Through Pipeline Criteria].Pipeline, DateSerial([TheYear],[TheMonth],1), [Month Name] & \, Count([SubQry Rpt Average Time Through Pipeline Criteria].[Entrepreneur ID]), Sum([SubQry Rpt Average Time Through Pipeline Criteria].[Pipeline Days]) FROM [SubQry Rpt Average Time Through Pipeline Criteria], [MonthLkUp]