Skip to content

Query: Qry SubRpt Daily Lead Summary Leads More Than 48 Hours All Divs

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])=1 Or (Entrepreneurs.[Process Status ID])=3

SQL

SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Process Status ID])=1 Or (Entrepreneurs.[Process Status ID])=3