Skip to content

Query: Qry Report Percentage Moved Last Week Digital

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

Tables Referenced

  • Qry Count Entrepreneur Moved Last Week Digital Process
  • SubQry
  • SubQry Rpt Percentage Moved Last Week Digital
  • Qry Count Entrepreneur Steps 1 to 7 Digital Process

Columns Selected

  • [SubQry Rpt Percentage Moved Last Week Digital].[Delivery Location ID]
  • [SubQry Rpt Percentage Moved Last Week Digital].[Distribution Model]
  • [SubQry Rpt Percentage Moved Last Week Digital].[Delivery Location]
  • [SubQry Rpt Percentage Moved Last Week Digital].[Number Steps 1 to 7]
  • [SubQry Rpt Percentage Moved Last Week Digital].[Entrepreneurs Moved Last Week]
  • [Entrepreneurs Moved Last Week]/[Number Steps 1 to 7]
  • IIf(IsNull([Total Moved Last Week]),0,[Total Moved Last Week])
  • [Qry Count Entrepreneur Steps 1 to 7 Digital Process].[Total Steps 1 to 7]
  • [Total Number Moved]/[Total Steps 1 to 7]

SQL

SELECT [SubQry Rpt Percentage Moved Last Week Digital].[Delivery Location ID], [SubQry Rpt Percentage Moved Last Week Digital].[Distribution Model], [SubQry Rpt Percentage Moved Last Week Digital].[Delivery Location], [SubQry Rpt Percentage Moved Last Week Digital].[Number Steps 1 to 7], [SubQry Rpt Percentage Moved Last Week Digital].[Entrepreneurs Moved Last Week], [Entrepreneurs Moved Last Week]/[Number Steps 1 to 7], IIf(IsNull([Total Moved Last Week]),0,[Total Moved Last Week]), [Qry Count Entrepreneur Steps 1 to 7 Digital Process].[Total Steps 1 to 7], [Total Number Moved]/[Total Steps 1 to 7] FROM [SubQry Rpt Percentage Moved Last Week Digital], [Qry Count Entrepreneur Moved Last Week Digital Process], [Qry Count Entrepreneur Steps 1 to 7 Digital Process]