Skip to content

Query: Qry SubRpt Daily Lead Summary Pipeline One Division

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

Tables Referenced

  • ProcessStatus
  • Entrepreneurs
  • Distribution Models
  • Delivery Locations

Columns Selected

  • Entrepreneurs.[Division ID]
  • Count(Entrepreneurs.[Entrepreneur ID])
  • [Distribution Models].[Distribution Model]
  • [Delivery Locations].[Delivery Location]

Where Clause

(((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))

SQL

SELECT Entrepreneurs.[Division ID], Count(Entrepreneurs.[Entrepreneur ID]), [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [ProcessStatus], [Delivery Locations], [Distribution Models] WHERE (((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))