Skip to content

Query: Qry SubRpt Daily Lead Summary New Leads 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.[Date Record Created])=Forms![Frm Reports Single Date Division 

SQL

SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Date Record Created])=Forms![Frm Reports Single Date Division