Skip to content

Query: Qry SubRpt Daily Lead Summary Uncontacted One Division

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

Tables Referenced

  • Entrepreneurs

Columns Selected

  • Count(Entrepreneurs.[Entrepreneur ID])

Where Clause

(((Entrepreneurs.[Process Status ID])=4) And ((Entrepreneurs.[Division ID])=Form

SQL

SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Process Status ID])=4) And ((Entrepreneurs.[Division ID])=Form