Skip to content

Query: Qry SubRpt Product Business Growth Criteria

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

Tables Referenced

  • Product Business Growth Criteria
  • Product
  • Business Growth Criteria LookUp

Columns Selected

  • [Product Business Growth Criteria].[Product Business Growth Criteria ID]
  • [Product Business Growth Criteria].[Product ID]
  • [Business Growth Criteria LookUp].[Business Growth Criteria]
  • [Business Growth Criteria LookUp].[Sort Order]
  • IIf([Business Growth Phase 1]=True,\
  • IIf([Business Growth Phase 2]=True,\
  • IIf([Business Growth Phase 3]=True,\

SQL

SELECT [Product Business Growth Criteria].[Product Business Growth Criteria ID], [Product Business Growth Criteria].[Product ID], [Business Growth Criteria LookUp].[Business Growth Criteria], [Business Growth Criteria LookUp].[Sort Order], IIf([Business Growth Phase 1]=True,\, IIf([Business Growth Phase 2]=True,\, IIf([Business Growth Phase 3]=True,\ FROM [Product Business Growth Criteria], [Business Growth Criteria LookUp]