Skip to content

Query: Qry Report Selection Daily Team Activity by Delivery Location

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

Tables Referenced

  • SubQry Rpt Count Unqualified by Del Loc
  • SubQry Rpt Count Meetings by Del Loc
  • SubQry Rpt Count Terminations by Del Loc
  • Delivery
  • SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc
  • SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc
  • Delivery Locations

Columns Selected

  • [Delivery Locations].[Distribution Model ID]
  • Active
  • [Delivery Locations].[Delivery Location]
  • [SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc].[Number of EPs Pipel
  • [SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc].[Number of EPs M
  • [Number of EPs Moved]/[Number of EPs Pipeline]
  • [SubQry Rpt Count Meetings by Del Loc].[Number of Meetings]
  • [SubQry Rpt Count Terminations by Del Loc].[Number of Terminations]
  • [SubQry Rpt Count Unqualified by Del Loc].[Number of Unqualified]

Where Clause

((([Delivery Locations].[Distribution Model ID])=Forms![Frm Reports Date Distrib

SQL

SELECT [Delivery Locations].[Distribution Model ID], [Delivery Locations].Active, [Delivery Locations].[Delivery Location], [SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc].[Number of EPs Pipel, [SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc].[Number of EPs M, [Number of EPs Moved]/[Number of EPs Pipeline], [SubQry Rpt Count Meetings by Del Loc].[Number of Meetings], [SubQry Rpt Count Terminations by Del Loc].[Number of Terminations], [SubQry Rpt Count Unqualified by Del Loc].[Number of Unqualified] FROM [Delivery Locations], [SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc], [SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc], [SubQry Rpt Count Meetings by Del Loc], [SubQry Rpt Count Terminations by Del Loc], [SubQry Rpt Count Unqualified by Del Loc] WHERE ((([Delivery Locations].[Distribution Model ID])=Forms![Frm Reports Date Distrib