Skip to content

Query: Qry Company Needs Replacement List

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

Tables Referenced

  • SubQry Company Needs Replacement List
  • SubQry
  • Qry Sum Total Billed by Company PP and Project Pillar
  • Qry Sum Replacement Amount Allocated by Replacement For

Columns Selected

  • [SubQry Company Needs Replacement List].[Entrepreneur Company Principal Project
  • [SubQry Company Needs Replacement List].[Principal Project Pillar ID]
  • [SubQry Company Needs Replacement List].[Replacement Status]
  • [SubQry Company Needs Replacement List].[Company Name]
  • [SubQry Company Needs Replacement List].[Principal Project]
  • [SubQry Company Needs Replacement List].[BBBEE Pillar]
  • [SubQry Company Needs Replacement List].[Allocated Amount]
  • Round([Total Billed])
  • Nz(Round([Total Replacement Amount]),0)+Nz(Round([Total Selection Fee]),0)
  • IIf(IsNull([TotalBilled]),0,[TotalBilled])
  • [Allocated Amount]-IIf(IsNull([TotalBilled]),0,[TotalBilled])-[TotalAllocated]

SQL

SELECT [SubQry Company Needs Replacement List].[Entrepreneur Company Principal Project , [SubQry Company Needs Replacement List].[Principal Project Pillar ID], [SubQry Company Needs Replacement List].[Replacement Status], [SubQry Company Needs Replacement List].[Company Name], [SubQry Company Needs Replacement List].[Principal Project], [SubQry Company Needs Replacement List].[BBBEE Pillar], [SubQry Company Needs Replacement List].[Allocated Amount], Round([Total Billed]), Nz(Round([Total Replacement Amount]),0)+Nz(Round([Total Selection Fee]),0), IIf(IsNull([TotalBilled]),0,[TotalBilled]), [Allocated Amount]-IIf(IsNull([TotalBilled]),0,[TotalBilled])-[TotalAllocated] FROM [SubQry Company Needs Replacement List], [Qry Sum Total Billed by Company PP and Project Pillar], [Qry Sum Replacement Amount Allocated by Replacement For]