Skip to content

Query: Qry SubRpt Daily Lead Summary Follow Up One Division

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

Tables Referenced

  • Entrepreneurs
  • Distribution Models
  • Delivery Locations

Columns Selected

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

Where Clause

(((Entrepreneurs.[Process Status ID])=1 Or (Entrepreneurs.[Process Status ID])=3

SQL

SELECT Entrepreneurs.[Division ID], Count(Entrepreneurs.[Entrepreneur ID]), [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [Delivery Locations], [Distribution Models] WHERE (((Entrepreneurs.[Process Status ID])=1 Or (Entrepreneurs.[Process Status ID])=3