Skip to content

Query: Qry SubRpt Daily Lead Summary Pipeline All Divisions

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

Tables Referenced

  • ProcessStatus
  • Entrepreneurs
  • Distribution Models
  • Delivery Locations

Columns Selected

  • 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 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))