Skip to content

Query: Qry Report Termination Analysis Successful Data

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

Tables Referenced

  • vwPurpleReportTerminationAnalysisSuccessfulData

Columns Selected

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

Where Clause

(((vwPurpleReportTerminationAnalysisSuccessfulData.[Date Status Changed])>=[Form

Order By

vwPurpleReportTerminationAnalysisSuccessfulData.[Step Number], [First Name] & \

SQL

SELECT vwPurpleReportTerminationAnalysisSuccessfulData.[Entrepreneur ID], vwPurpleReportTerminationAnalysisSuccessfulData.[Entrepreneur Company ID], vwPurpleReportTerminationAnalysisSuccessfulData.[Date Status Changed], vwPurpleReportTerminationAnalysisSuccessfulData.[Process Status ID], vwPurpleReportTerminationAnalysisSuccessfulData.[Step Number], [First Name] & \, vwPurpleReportTerminationAnalysisSuccessfulData.Status, vwPurpleReportTerminationAnalysisSuccessfulData.[Company Name], vwPurpleReportTerminationAnalysisSuccessfulData.[Lead Type], vwPurpleReportTerminationAnalysisSuccessfulData.Industry, [Principal] & \, vwPurpleReportTerminationAnalysisSuccessfulData.[Recommended Product] FROM [vwPurpleReportTerminationAnalysisSuccessfulData] WHERE (((vwPurpleReportTerminationAnalysisSuccessfulData.[Date Status Changed])>=[Form