Skip to content

Query: Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location

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

Tables Referenced

  • vwPurpleGetEntrepreneursSteps1to7

Columns Selected

  • vwPurpleGetEntrepreneursSteps1to7.[Delivery Location ID]
  • vwPurpleGetEntrepreneursSteps1to7.[Distribution Model]
  • vwPurpleGetEntrepreneursSteps1to7.[Delivery Location]
  • Count(vwPurpleGetEntrepreneursSteps1to7.[Entrepreneur ID])

Where Clause

(((vwPurpleGetEntrepreneursSteps1to7.[Selection Type])=1))

SQL

SELECT vwPurpleGetEntrepreneursSteps1to7.[Delivery Location ID], vwPurpleGetEntrepreneursSteps1to7.[Distribution Model], vwPurpleGetEntrepreneursSteps1to7.[Delivery Location], Count(vwPurpleGetEntrepreneursSteps1to7.[Entrepreneur ID]) FROM [vwPurpleGetEntrepreneursSteps1to7] WHERE (((vwPurpleGetEntrepreneursSteps1to7.[Selection Type])=1))