Skip to content

Query: SubQry Rpt Lead Type to Principal Allocation Criteria

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

Tables Referenced

  • vwPurpleRptLeadTypetoPrincipalAllocationCriteria

Columns Selected

  • vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type Principal Project ID
  • vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type]
  • IIf(IsNull([Allocated Principal Project ID]),\
  • IIf(IsNull([Company Status]),[Process Status],[Company Status])
  • vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Entrepreneur ID]
  • vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Company Name]
  • [First Name] & \
  • [Lead Principal] & \
  • [Allocated Principal] & \

Where Clause

(((vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type Principal Project

Order By

IIf(IsNull([Allocated Principal Project ID]),\, IIf(IsNull([Company Status]),[Process Status],[Company Status])

SQL

SELECT vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type Principal Project ID, vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type], IIf(IsNull([Allocated Principal Project ID]),\, IIf(IsNull([Company Status]),[Process Status],[Company Status]), vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Entrepreneur ID], vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Company Name], [First Name] & \, [Lead Principal] & \, [Allocated Principal] & \ FROM [vwPurpleRptLeadTypetoPrincipalAllocationCriteria] WHERE (((vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type Principal Project