Skip to content

Query: Qry Report Purple Panel Results Unsuccessful

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].[Process Status ID]
  • [SubQry Report Purple Panel Results].[Entrepreneur Company ID]
  • Passed
  • Entrepreneur
  • [SubQry Report Purple Panel Results].[Company Name]
  • Individuals
  • [SubQry Report Purple Panel Results].[Delivery Location]
  • [SubQry Report Purple Panel Results].[Purple Panel Date]
  • [SubQry Report Purple Panel Results].[Rec Product]
  • [SubQry Report Purple Panel Results].[Convener Name]
  • [SubQry Report Purple Panel Results].[The Score]
  • [SubQry Report Purple Panel Results].[Strengths Summary]
  • [SubQry Report Purple Panel Results].[Developmental Areas Summary]
  • [SubQry Report Purple Panel Results].[Rec Product]

Where Clause

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

SQL

SELECT [SubQry Report Purple Panel Results].[Purple Panel ID], [SubQry Report Purple Panel Results].[Process Status ID], [SubQry Report Purple Panel Results].[Entrepreneur Company ID], [SubQry Report Purple Panel Results].Passed, [SubQry Report Purple Panel Results].Entrepreneur, [SubQry Report Purple Panel Results].[Company Name], [Temp Individuals in a Company].Individuals, [SubQry Report Purple Panel Results].[Delivery Location], [SubQry Report Purple Panel Results].[Purple Panel Date], [SubQry Report Purple Panel Results].[Rec Product], [SubQry Report Purple Panel Results].[Convener Name], [SubQry Report Purple Panel Results].[The Score], [SubQry Report Purple Panel Results].[Strengths Summary], [SubQry Report Purple Panel Results].[Developmental Areas Summary], [SubQry Report Purple Panel Results].[Rec Product] FROM [SubQry Report Purple Panel Results], [Temp Individuals in a Company] WHERE ((([SubQry Report Purple Panel Results].[Purple Panel ID])=[Forms]![Frm Company