Skip to content

Query: Qry Report Partner Elite Pipeline Unqualified or Terminated

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

Tables Referenced

  • Lead Types
  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Lead Type ID]
  • [Lead Types].[Lead Type]
  • Count(Entrepreneurs.[Entrepreneur ID])

Where Clause

(((Entrepreneurs.[Division ID])=3) AND ((Entrepreneurs.[Process Status ID])=41 O

Order By

[Lead Types].[Lead Type]

SQL

SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [Lead Types] WHERE (((Entrepreneurs.[Division ID])=3) AND ((Entrepreneurs.[Process Status ID])=41 O