Skip to content

Query: Qry Report Percentage Moved Last Week Manual

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

Tables Referenced

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

Columns Selected

  • [SubQry Rpt Percentage Moved Last Week Manual].[Delivery Location ID]
  • [SubQry Rpt Percentage Moved Last Week Manual].[Distribution Model]
  • [SubQry Rpt Percentage Moved Last Week Manual].[Delivery Location]
  • [SubQry Rpt Percentage Moved Last Week Manual].[Number Steps 1 to 7]
  • [SubQry Rpt Percentage Moved Last Week Manual].[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 Manual Process].[Total Steps 1 to 7]
  • [Total Number Moved]/[Total Steps 1 to 7]

SQL

SELECT [SubQry Rpt Percentage Moved Last Week Manual].[Delivery Location ID], [SubQry Rpt Percentage Moved Last Week Manual].[Distribution Model], [SubQry Rpt Percentage Moved Last Week Manual].[Delivery Location], [SubQry Rpt Percentage Moved Last Week Manual].[Number Steps 1 to 7], [SubQry Rpt Percentage Moved Last Week Manual].[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 Manual Process].[Total Steps 1 to 7], [Total Number Moved]/[Total Steps 1 to 7] FROM [Qry Count Entrepreneur Steps 1 to 7 Manual Process], [Qry Count Entrepreneur Moved Last Week Manual Process], [SubQry Rpt Percentage Moved Last Week Manual]