Skip to content

Query: Qry Entrepreneur List Ignition Dashboard

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

Tables Referenced

  • vwPurpleEntrepreneurListIgnitionDashboard

Columns Selected

  • vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur ID]
  • vwPurpleEntrepreneurListIgnitionDashboard.[Student ID]
  • vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company ID]
  • vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company Programme Years
  • vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company Principal Projec
  • vwPurpleEntrepreneurListIgnitionDashboard.[Ignition Date]
  • IIf([Ignition Date]<Date(),\
  • vwPurpleEntrepreneurListIgnitionDashboard.[Company Name]
  • vwPurpleEntrepreneurListIgnitionDashboard.[Company Status ID]
  • Status
  • vwPurpleEntrepreneurListIgnitionDashboard.[Date Status Changed]
  • vwPurpleEntrepreneurListIgnitionDashboard.[Status Modified By]
  • Province
  • Industry
  • vwPurpleEntrepreneurListIgnitionDashboard.[Delivery Location]
  • OwnedBy
  • vwPurpleEntrepreneurListIgnitionDashboard.[Process Status ID]
  • vwPurpleEntrepreneurListIgnitionDashboard.[Date Record Created]
  • [Principal] & \
  • vwPurpleEntrepreneurListIgnitionDashboard.[Process Date]
  • Product
  • vwPurpleEntrepreneurListIgnitionDashboard.[Programme Year]
  • vwPurpleEntrepreneurListIgnitionDashboard.[Contract Start Date]

SQL

SELECT vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur ID], vwPurpleEntrepreneurListIgnitionDashboard.[Student ID], vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company ID], vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company Programme Years , vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company Principal Projec, vwPurpleEntrepreneurListIgnitionDashboard.[Ignition Date], IIf([Ignition Date]<Date(),\, vwPurpleEntrepreneurListIgnitionDashboard.[Company Name], vwPurpleEntrepreneurListIgnitionDashboard.[Company Status ID], vwPurpleEntrepreneurListIgnitionDashboard.Status, vwPurpleEntrepreneurListIgnitionDashboard.[Date Status Changed], vwPurpleEntrepreneurListIgnitionDashboard.[Status Modified By], vwPurpleEntrepreneurListIgnitionDashboard.Province, vwPurpleEntrepreneurListIgnitionDashboard.Industry, vwPurpleEntrepreneurListIgnitionDashboard.[Delivery Location], vwPurpleEntrepreneurListIgnitionDashboard.OwnedBy, vwPurpleEntrepreneurListIgnitionDashboard.[Process Status ID], vwPurpleEntrepreneurListIgnitionDashboard.[Date Record Created], [Principal] & \, vwPurpleEntrepreneurListIgnitionDashboard.[Process Date], vwPurpleEntrepreneurListIgnitionDashboard.Product, vwPurpleEntrepreneurListIgnitionDashboard.[Programme Year], vwPurpleEntrepreneurListIgnitionDashboard.[Contract Start Date] FROM [vwPurpleEntrepreneurListIgnitionDashboard]