Skip to content

Query: Qry Count Total Companies Allocated Lump Sum 1 Principal Project

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

Tables Referenced

  • Principal Project Pillars
  • Entrepreneur
  • Principal Projects
  • Entrepreneur Company Principal Projects

Columns Selected

  • [Entrepreneur Company Principal Projects].[Lump Sum Allocation]
  • Count([Entrepreneur Company Principal Projects].[Entrepreneur Company Principal
  • [Principal Projects].[Principal Project ID]

SQL

SELECT [Entrepreneur Company Principal Projects].[Lump Sum Allocation], Count([Entrepreneur Company Principal Projects].[Entrepreneur Company Principal , [Principal Projects].[Principal Project ID] FROM [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects]