Skip to content

Query: Qry Report Termination Analysis Data

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

Tables Referenced

  • vwPurpleReportTerminationAnalysisData

Columns Selected

  • vwPurpleReportTerminationAnalysisData.[Entrepreneur ID]
  • vwPurpleReportTerminationAnalysisData.[Entrepreneur Company ID]
  • vwPurpleReportTerminationAnalysisData.[Date Status Changed]
  • vwPurpleReportTerminationAnalysisData.[Process Status ID]
  • vwPurpleReportTerminationAnalysisData.[Step Number]
  • [First Name] & \
  • Status
  • vwPurpleReportTerminationAnalysisData.[History Date Status Changed]
  • vwPurpleReportTerminationAnalysisData.[Company Name]
  • vwPurpleReportTerminationAnalysisData.[Lead Type]
  • Industry
  • [Principal] & \
  • vwPurpleReportTerminationAnalysisData.[Recommended Product]
  • vwPurpleReportTerminationAnalysisData.[Termination Reason]

Where Clause

(((vwPurpleReportTerminationAnalysisData.[Date Status Changed])>=[Forms]![Frm Re

Order By

[First Name] & \

SQL

SELECT vwPurpleReportTerminationAnalysisData.[Entrepreneur ID], vwPurpleReportTerminationAnalysisData.[Entrepreneur Company ID], vwPurpleReportTerminationAnalysisData.[Date Status Changed], vwPurpleReportTerminationAnalysisData.[Process Status ID], vwPurpleReportTerminationAnalysisData.[Step Number], [First Name] & \, vwPurpleReportTerminationAnalysisData.Status, vwPurpleReportTerminationAnalysisData.[History Date Status Changed], vwPurpleReportTerminationAnalysisData.[Company Name], vwPurpleReportTerminationAnalysisData.[Lead Type], vwPurpleReportTerminationAnalysisData.Industry, [Principal] & \, vwPurpleReportTerminationAnalysisData.[Recommended Product], vwPurpleReportTerminationAnalysisData.[Termination Reason] FROM [vwPurpleReportTerminationAnalysisData] WHERE (((vwPurpleReportTerminationAnalysisData.[Date Status Changed])>=[Forms]![Frm Re