Skip to content

Query: Qry Report Purple Panel Feedback to COO

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

Tables Referenced

  • Temp Individuals in a Company
  • SubQry Report Purple Panel Results
  • SubQry

Columns Selected

  • [SubQry Report Purple Panel Results].[Purple Panel ID]
  • [SubQry Report Purple Panel Results].[Panel Feedback to COO]
  • [SubQry Report Purple Panel Results].[Entrepreneur Company ID]
  • [SubQry Report Purple Panel Results].[Company Name]
  • Individuals
  • [SubQry Report Purple Panel Results].[Purple Panel Date]
  • [SubQry Report Purple Panel Results].[Purple Panel Time]
  • [SubQry Report Purple Panel Results].[Recommended Product]
  • [SubQry Report Purple Panel Results].[Suitabe for Recommended Programme]
  • [SubQry Report Purple Panel Results].[Suitable for Rec Programme]
  • [SubQry Report Purple Panel Results].[Rec Product]
  • [SubQry Report Purple Panel Results].[Convener Name]
  • [SubQry Report Purple Panel Results].[The Score]
  • IIf([Passed]=True,\
  • [SubQry Report Purple Panel Results].[Purple Panel Status]

Where Clause

((([SubQry Report Purple Panel Results].[Purple Panel ID])=Forms![Frm Edit Purpl

SQL

SELECT [SubQry Report Purple Panel Results].[Purple Panel ID], [SubQry Report Purple Panel Results].[Panel Feedback to COO], [SubQry Report Purple Panel Results].[Entrepreneur Company ID], [SubQry Report Purple Panel Results].[Company Name], [Temp Individuals in a Company].Individuals, [SubQry Report Purple Panel Results].[Purple Panel Date], [SubQry Report Purple Panel Results].[Purple Panel Time], [SubQry Report Purple Panel Results].[Recommended Product], [SubQry Report Purple Panel Results].[Suitabe for Recommended Programme], [SubQry Report Purple Panel Results].[Suitable for Rec Programme], [SubQry Report Purple Panel Results].[Rec Product], [SubQry Report Purple Panel Results].[Convener Name], [SubQry Report Purple Panel Results].[The Score], IIf([Passed]=True,\, [SubQry Report Purple Panel Results].[Purple Panel Status] FROM [SubQry Report Purple Panel Results], [Temp Individuals in a Company] WHERE ((([SubQry Report Purple Panel Results].[Purple Panel ID])=Forms![Frm Edit Purpl