Skip to content

Query: Qry SubRpt Daily Lead Summary New Leads by Lead Type One Div

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.[Division ID])=Forms![Frm Reports Single Date Division Dialog]!

SQL

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