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]