Skip to content

Query: SubQry Get Last Programme Year for Exited Companies

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

Tables Referenced

  • Principal Projects
  • Entrepreneur Company
  • Principals
  • Principal
  • Qry Sum Total Spend by Principal Project
  • Entrepreneur Company Programme Years

Columns Selected

  • [Entrepreneur Company Programme Years].[Entrepreneur Company ID]
  • Max([Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years

Where Clause

((([Entrepreneur Company].[Company Status ID])=4 Or ([Entrepreneur Company].[Com

Order By

[Entrepreneur Company Programme Years].[Entrepreneur Company ID]

SQL

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company ID], Max([Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years FROM [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [Entrepreneur Company], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company].[Company Status ID])=4 Or ([Entrepreneur Company].[Com