Skip to content

Query: Qry SubRpt Product Selection Criteria Business Exp

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 Time in Business]
  • [Product Selection Criteria and Assessment].[Financial Records Months]
  • IIf([Financial Records Audited]=1,\
  • [Product Selection Criteria and Assessment].[Minimum Average Turnover per Month]
  • [Product Selection Criteria and Assessment].[Other Business Criteria NA]
  • [Product Selection Criteria and Assessment].[Other Business Criteria]
  • [Product Selection Criteria and Assessment].[Current Industry Operating NA]
  • [Product Selection Criteria and Assessment].[Current Industry Operating]
  • [Product Selection Criteria and Assessment].[Experience in Industry NA]
  • [Product Selection Criteria and Assessment].[Experience in Industry]
  • [Product Selection Criteria and Assessment].[Interest in Industry NA]
  • [Product Selection Criteria and Assessment].[Interest in Industry]
  • [Product Selection Criteria and Assessment].[Maths NQF Level NA]
  • [Product Selection Criteria and Assessment].[Maths NQF Level]
  • [Product Selection Criteria and Assessment].[English NQF Level NA]
  • [Product Selection Criteria and Assessment].[English NQF Level]
  • [Product Selection Criteria and Assessment].[Other NQF Level NA]
  • [Product Selection Criteria and Assessment].[Other NQF Level]
  • [Product Selection Criteria and Assessment].[Other Qualification NA]
  • [Product Selection Criteria and Assessment].[Other Qualification]

SQL

SELECT [Product Selection Criteria and Assessment].[Product ID], [Product Selection Criteria and Assessment].[Phase Number], [Product Selection Criteria and Assessment].[Minimum Time in Business], [Product Selection Criteria and Assessment].[Financial Records Months], IIf([Financial Records Audited]=1,\, [Product Selection Criteria and Assessment].[Minimum Average Turnover per Month], [Product Selection Criteria and Assessment].[Other Business Criteria NA], [Product Selection Criteria and Assessment].[Other Business Criteria], [Product Selection Criteria and Assessment].[Current Industry Operating NA], [Product Selection Criteria and Assessment].[Current Industry Operating], [Product Selection Criteria and Assessment].[Experience in Industry NA], [Product Selection Criteria and Assessment].[Experience in Industry], [Product Selection Criteria and Assessment].[Interest in Industry NA], [Product Selection Criteria and Assessment].[Interest in Industry], [Product Selection Criteria and Assessment].[Maths NQF Level NA], [Product Selection Criteria and Assessment].[Maths NQF Level], [Product Selection Criteria and Assessment].[English NQF Level NA], [Product Selection Criteria and Assessment].[English NQF Level], [Product Selection Criteria and Assessment].[Other NQF Level NA], [Product Selection Criteria and Assessment].[Other NQF Level], [Product Selection Criteria and Assessment].[Other Qualification NA], [Product Selection Criteria and Assessment].[Other Qualification] FROM [Product Selection Criteria and Assessment]