Skip to content

Query: Qry Report Entrepreneur Summary by Distribution Model

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

Tables Referenced

  • vwPurpleReportEntrepreneurSummary

Columns Selected

  • vwPurpleReportEntrepreneurSummary.[Distribution Model ID]
  • vwPurpleReportEntrepreneurSummary.[The Product]
  • vwPurpleReportEntrepreneurSummary.[Delivery Location]
  • vwPurpleReportEntrepreneurSummary.[Process Step]
  • vwPurpleReportEntrepreneurSummary.[Step Number]
  • Round(Sum([Weighted EP]),2)
  • Count(vwPurpleReportEntrepreneurSummary.[Entrepreneur ID])

Order By

vwPurpleReportEntrepreneurSummary.[Delivery Location], vwPurpleReportEntrepreneurSummary.[Step Number]

SQL

SELECT vwPurpleReportEntrepreneurSummary.[Distribution Model ID], vwPurpleReportEntrepreneurSummary.[The Product], vwPurpleReportEntrepreneurSummary.[Delivery Location], vwPurpleReportEntrepreneurSummary.[Process Step], vwPurpleReportEntrepreneurSummary.[Step Number], Round(Sum([Weighted EP]),2), Count(vwPurpleReportEntrepreneurSummary.[Entrepreneur ID]) FROM [vwPurpleReportEntrepreneurSummary]