Skip to content

Query: Qry Report Marketing Pre-Unqualified Leads

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

Tables Referenced

  • UnqualifiedReason
  • Lead Types
  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Date Record Created]
  • Entrepreneurs.[Reference Number]
  • [Lead Types].[Lead Type]
  • [First Name] & \
  • Entrepreneurs.[EOI Business Name]
  • Entrepreneurs.[Email Address]
  • Status
  • UnqualifiedReason.[Unqualified Reason]
  • ProcessStatus.[Process Status ID]
  • UnqualifiedReason.[Unqualified Reason ID]

Where Clause

(((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Marketing Lead Report Date

Order By

[Lead Types].[Lead Type], [First Name] & \

SQL

SELECT Entrepreneurs.[Date Record Created], Entrepreneurs.[Reference Number], [Lead Types].[Lead Type], [First Name] & \, Entrepreneurs.[EOI Business Name], Entrepreneurs.[Email Address], ProcessStatus.Status, UnqualifiedReason.[Unqualified Reason], ProcessStatus.[Process Status ID], UnqualifiedReason.[Unqualified Reason ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Marketing Lead Report Date