Skip to content

Query: Qry SubRpt Daily Lead Summary New Leads by Lead Type All Divs

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

Tables Referenced

  • Lead Types
  • Entrepreneurs

Columns Selected

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

Where Clause

(((Entrepreneurs.[Date Record Created])=[Forms]![Frm Reports Single Date Divisio

SQL

SELECT [Lead Types].[Lead Type], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Lead Types] WHERE (((Entrepreneurs.[Date Record Created])=[Forms]![Frm Reports Single Date Divisio