Skip to content

Query: Qry Report Recommended Principal Project Allocation

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

Tables Referenced

  • Principal Projects
  • Products
  • SubQry Rpt Recommended Principal Project Allocation
  • SubQry
  • Principals
  • Qry Sum Total Spend by Principal Project
  • Delivery Locations

Columns Selected

  • [SubQry Rpt Recommended Principal Project Allocation].[The Principal Project ID]
  • [Principal] & \
  • Entrepreneur
  • [SubQry Rpt Recommended Principal Project Allocation].[The Status]
  • [SubQry Rpt Recommended Principal Project Allocation].[Allocated Amount]
  • IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje
  • [SubQry Rpt Recommended Principal Project Allocation].[Company Name]

Order By

[Principal] & \

SQL

SELECT [SubQry Rpt Recommended Principal Project Allocation].[The Principal Project ID], [Principal] & \, [SubQry Rpt Recommended Principal Project Allocation].Entrepreneur, [SubQry Rpt Recommended Principal Project Allocation].[The Status], [SubQry Rpt Recommended Principal Project Allocation].[Allocated Amount], IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje, [SubQry Rpt Recommended Principal Project Allocation].[Company Name] FROM [SubQry Rpt Recommended Principal Project Allocation], [Principal Projects], [Principals], [Products], [Qry Sum Total Spend by Principal Project], [Delivery Locations]