Skip to content

Query: Qry Entrepreneur List Part Sponsorship

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

Tables Referenced

  • vwPurpleEntrepreneurListPartSponsorship
  • Qry
  • Qry Sum Total Allocated Amt by Company

Columns Selected

  • vwPurpleEntrepreneurListPartSponsorship.[Process Status ID]
  • vwPurpleEntrepreneurListPartSponsorship.[Lump Sum Allocation]
  • vwPurpleEntrepreneurListPartSponsorship.[Entrepreneur Company ID]
  • vwPurpleEntrepreneurListPartSponsorship.[Entrepreneur ID]
  • vwPurpleEntrepreneurListPartSponsorship.[Company Status ID]
  • OwnedBy
  • Status
  • vwPurpleEntrepreneurListPartSponsorship.[Date Status Changed]
  • vwPurpleEntrepreneurListPartSponsorship.[Delivery Location]
  • vwPurpleEntrepreneurListPartSponsorship.[Company Name]
  • [First Name] & \
  • Industry
  • vwPurpleEntrepreneurListPartSponsorship.[Total Programme Amount]
  • Principal
  • vwPurpleEntrepreneurListPartSponsorship.[Project Name]
  • vwPurpleEntrepreneurListPartSponsorship.[Recommended Product]
  • Yr
  • IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Amt])
  • [Total Programme Amount]-IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Am
  • [Principal] & \

SQL

SELECT vwPurpleEntrepreneurListPartSponsorship.[Process Status ID], vwPurpleEntrepreneurListPartSponsorship.[Lump Sum Allocation], vwPurpleEntrepreneurListPartSponsorship.[Entrepreneur Company ID], vwPurpleEntrepreneurListPartSponsorship.[Entrepreneur ID], vwPurpleEntrepreneurListPartSponsorship.[Company Status ID], vwPurpleEntrepreneurListPartSponsorship.OwnedBy, vwPurpleEntrepreneurListPartSponsorship.Status, vwPurpleEntrepreneurListPartSponsorship.[Date Status Changed], vwPurpleEntrepreneurListPartSponsorship.[Delivery Location], vwPurpleEntrepreneurListPartSponsorship.[Company Name], [First Name] & \, vwPurpleEntrepreneurListPartSponsorship.Industry, vwPurpleEntrepreneurListPartSponsorship.[Total Programme Amount], vwPurpleEntrepreneurListPartSponsorship.Principal, vwPurpleEntrepreneurListPartSponsorship.[Project Name], vwPurpleEntrepreneurListPartSponsorship.[Recommended Product], vwPurpleEntrepreneurListPartSponsorship.Yr, IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Amt]), [Total Programme Amount]-IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Am, [Principal] & \ FROM [Qry Sum Total Allocated Amt by Company], [vwPurpleEntrepreneurListPartSponsorship]