Skip to content

Query: SubQry Rpt Recommended Principal Project Allocation

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

Tables Referenced

  • Principal Project Pillars
  • Entrepreneur Company Principal Projects
  • CompanyStatus
  • Entrepreneur Company
  • ProcessStatus
  • Entrepreneur Company Programme Years
  • Entrepreneurs

Columns Selected

  • IIf(IsNull([Entrepreneur Company].[Company Status ID]),[ProcessStatus].[Status],
  • [Entrepreneur Company].[Company Status ID]
  • ProcessStatus.[Step Number]
  • IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company Principal Projects].[Allocated Amount]
  • [First Name] & \
  • IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),[Recommended Pro

Where Clause

((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com

Order By

[Entrepreneur Company].[Company Name]

SQL

SELECT IIf(IsNull([Entrepreneur Company].[Company Status ID]),[ProcessStatus].[Status],, [Entrepreneur Company].[Company Status ID], ProcessStatus.[Step Number], IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal, [Entrepreneur Company].[Company Name], [Entrepreneur Company Principal Projects].[Allocated Amount], [First Name] & \, IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),[Recommended Pro FROM [Entrepreneurs], [ProcessStatus], [Principal Project Pillars], [Entrepreneur Company], [CompanyStatus], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com