Skip to content

Query: Qry Report EOI Entrepreneur

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

Tables Referenced

  • CountryLookup
  • Entrepreneurs
  • Divisions

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]
  • Entrepreneurs.[Entrepreneur Company ID]
  • Division
  • [First Name] & \
  • Country
  • Entrepreneurs.[SA Citizen]
  • Province
  • Entrepreneurs.[Identity Number]
  • IIf([SAID]=True,\
  • Entrepreneurs.[Date of Birth]
  • Int(DateDiff(\
  • Entrepreneurs.[EOI Citizendship Country]
  • Entrepreneurs.[EOI Ownership Structure]
  • Gender
  • Race
  • Location
  • Entrepreneurs.[Telephone Number]
  • Entrepreneurs.[Second Telephone Number]
  • Entrepreneurs.[Email Address]
  • Entrepreneurs.[Alternative Email Address]
  • Entrepreneurs.[Date Record Created]
  • Entrepreneurs.[Full Time]
  • Entrepreneurs.[Shareholding Percentage]
  • Entrepreneurs.[Style Questionnaire Score]
  • Entrepreneurs.[Style Questionnaire Results]
  • Entrepreneurs.[Personal Audit Score]
  • Entrepreneurs.[Personal Audit Results]
  • Entrepreneurs.[Urgency Result]
  • Entrepreneurs.[Financial Literacy Result]
  • IIf([Entrepreneurial Assessment Results]=1,\
  • Entrepreneurs.[EA Date]
  • Entrepreneurs.[EA Marker]
  • IIf([EA Retake Results]=1,\
  • Entrepreneurs.[EA Retake Date]
  • Entrepreneurs.[EA Retake Marker]
  • IIf([PP Results]=1,\
  • Entrepreneurs.[Purple Panel Score]
  • Entrepreneurs.[Date Panel Held]

SQL

SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Entrepreneur Company ID], Divisions.Division, [First Name] & \, CountryLookup.Country, Entrepreneurs.[SA Citizen], Entrepreneurs.Province, Entrepreneurs.[Identity Number], IIf([SAID]=True,\, Entrepreneurs.[Date of Birth], Int(DateDiff(\, Entrepreneurs.[EOI Citizendship Country], Entrepreneurs.[EOI Ownership Structure], Entrepreneurs.Gender, Entrepreneurs.Race, Entrepreneurs.Location, Entrepreneurs.[Telephone Number], Entrepreneurs.[Second Telephone Number], Entrepreneurs.[Email Address], Entrepreneurs.[Alternative Email Address], Entrepreneurs.[Date Record Created], Entrepreneurs.[Full Time], Entrepreneurs.[Shareholding Percentage], Entrepreneurs.[Style Questionnaire Score], Entrepreneurs.[Style Questionnaire Results], Entrepreneurs.[Personal Audit Score], Entrepreneurs.[Personal Audit Results], Entrepreneurs.[Urgency Result], Entrepreneurs.[Financial Literacy Result], IIf([Entrepreneurial Assessment Results]=1,\, Entrepreneurs.[EA Date], Entrepreneurs.[EA Marker], IIf([EA Retake Results]=1,\, Entrepreneurs.[EA Retake Date], Entrepreneurs.[EA Retake Marker], IIf([PP Results]=1,\, Entrepreneurs.[Purple Panel Score], Entrepreneurs.[Date Panel Held] FROM [Entrepreneurs], [Divisions], [CountryLookup]