Query: Qry Count Exited Need Replacement by Principal Project Pillar

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

Tables Referenced

Entrepreneur
Entrepreneur Company
Entrepreneur Company Programme Years
Entrepreneur Company Principal Projects

Columns Selected

[Entrepreneur Company Principal Projects].[Principal Project Pillar ID]
Count([Entrepreneur Company].[Entrepreneur Company ID])
[Entrepreneur Company Programme Years].[Company Programme Year Status ID]

Where Clause

((([Entrepreneur Company Principal Projects].[Replacement Status])=\"Needs Repla

SQL

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Count([Entrepreneur Company].[Entrepreneur Company ID]), [Entrepreneur Company Programme Years].[Company Programme Year Status ID] FROM [Entrepreneur Company], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status])=\"Needs Repla