Skip to content

Query: Qry Get Lead Types for Passed Panel Entrepreneurs

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

Tables Referenced

  • Entrepreneurs
  • ProcessStatus
  • Lead Types

Columns Selected

  • Entrepreneurs.[Lead Type ID]
  • [Lead Types].[Lead Source]
  • Entrepreneurs.[PP Results]

Where Clause

(((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Marketing Lead Report Date Dia

SQL

SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Source], Entrepreneurs.[PP Results] FROM [Entrepreneurs], [Lead Types], [ProcessStatus] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Marketing Lead Report Date Dia