Skip to content

Query: Qry SubRpt Product Selection Criteria EP Resource

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

Tables Referenced

  • Product
  • Product Selection Criteria and Assessment

Columns Selected

  • [Product Selection Criteria and Assessment].[Product ID]
  • [Product Selection Criteria and Assessment].[Phase Number]
  • [Product Selection Criteria and Assessment].[Minimum Age]
  • [Product Selection Criteria and Assessment].[Minimum Age Other]
  • [Product Selection Criteria and Assessment].[Minimum BBBEE]
  • [Product Selection Criteria and Assessment].[Location Requirement]
  • [Product Selection Criteria and Assessment].[Level of Participation]
  • IIf([Credit Check Permission Required]=1,\
  • IIf([Criminal Check Permission Required]=1,\
  • IIf([Cell Phone Required]=1,\
  • [Product Selection Criteria and Assessment].[Computer Resource]
  • [Product Selection Criteria and Assessment].[Transport Resource]
  • IIf([Gender Specific]=1,\

SQL

SELECT [Product Selection Criteria and Assessment].[Product ID], [Product Selection Criteria and Assessment].[Phase Number], [Product Selection Criteria and Assessment].[Minimum Age], [Product Selection Criteria and Assessment].[Minimum Age Other], [Product Selection Criteria and Assessment].[Minimum BBBEE], [Product Selection Criteria and Assessment].[Location Requirement], [Product Selection Criteria and Assessment].[Level of Participation], IIf([Credit Check Permission Required]=1,\, IIf([Criminal Check Permission Required]=1,\, IIf([Cell Phone Required]=1,\, [Product Selection Criteria and Assessment].[Computer Resource], [Product Selection Criteria and Assessment].[Transport Resource], IIf([Gender Specific]=1,\ FROM [Product Selection Criteria and Assessment]