Skip to content

Query: SubQry Report Purple Panel Results

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

Tables Referenced

  • vwGIAEntrepreneurList
  • Qry Get Purple Panel Convener Name by Purple Panel
  • Products
  • Purple Panels
  • Purple
  • Purple Panel Status Lookup

Columns Selected

  • vwGIAEntrepreneurList.[Entrepreneur ID]
  • [Purple Panels].[Purple Panel ID]
  • vwGIAEntrepreneurList.[Process Status ID]
  • [First Name] & \
  • [Purple Panels].[Entrepreneur Company ID]
  • vwGIAEntrepreneurList.[Company Name]
  • vwGIAEntrepreneurList.[Delivery Location]
  • [Purple Panels].[Purple Panel Date]
  • [Purple Panels].[Purple Panel Time]
  • [Purple Panels].[Recommended Product]
  • [Purple Panels].[Suitabe for Recommended Programme]
  • IIf([Suitabe for Recommended Programme]=1,\
  • IIf([Suitabe for Recommended Programme]=1,[Purple Panels].[Recommended Product],
  • [Qry Get Purple Panel Convener Name by Purple Panel].[Convener Name]
  • IIf(IsNull([Adjusted Average Score]) Or [Adjusted Average Score]=0,[Average Scor
  • Passed
  • [Purple Panel Status Lookup].[Purple Panel Status]
  • [Purple Panels].[Strengths Summary]
  • [Purple Panels].[Developmental Areas Summary]
  • [Purple Panels].[Panel Feedback to COO]

SQL

SELECT vwGIAEntrepreneurList.[Entrepreneur ID], [Purple Panels].[Purple Panel ID], vwGIAEntrepreneurList.[Process Status ID], [First Name] & \, [Purple Panels].[Entrepreneur Company ID], vwGIAEntrepreneurList.[Company Name], vwGIAEntrepreneurList.[Delivery Location], [Purple Panels].[Purple Panel Date], [Purple Panels].[Purple Panel Time], [Purple Panels].[Recommended Product], [Purple Panels].[Suitabe for Recommended Programme], IIf([Suitabe for Recommended Programme]=1,\, IIf([Suitabe for Recommended Programme]=1,[Purple Panels].[Recommended Product],, [Qry Get Purple Panel Convener Name by Purple Panel].[Convener Name], IIf(IsNull([Adjusted Average Score]) Or [Adjusted Average Score]=0,[Average Scor, [Purple Panel Status Lookup].Passed, [Purple Panel Status Lookup].[Purple Panel Status], [Purple Panels].[Strengths Summary], [Purple Panels].[Developmental Areas Summary], [Purple Panels].[Panel Feedback to COO] FROM [Purple Panels], [Qry Get Purple Panel Convener Name by Purple Panel], [Purple Panel Status Lookup], [vwGIAEntrepreneurList], [Products]