Skip to content

Query: Qry Get Monthly Billing Information

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

Tables Referenced

  • Entrepreneur Company Programme Years
  • Qry Sum Total Billed by Company PP and Project Pillar
  • Qry Get Last Billing Date by EP Company Principal Project
  • Entrepreneur
  • Entrepreneur Company Principal Projects

Columns Selected

  • [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec
  • [Entrepreneur Company Programme Years].[Entrepreneur Company ID]
  • [Entrepreneur Company Principal Projects].[Principal Project Pillar ID]
  • [Entrepreneur Company Principal Projects].[Monthly Allocated Amount]
  • Month([Date Status Changed])
  • Year([Date Status Changed])
  • [Entrepreneur Company Programme Years].[Date Status Changed]
  • [Entrepreneur Company Programme Years].[Company Programme Year Status ID]
  • Month([Last Billing Date])
  • [Entrepreneur Company Principal Projects].[Lump Sum Allocation]
  • Round(IIf(IsNull([Total Billed]),0,[Total Billed]),2)
  • Round([Allocated Amount]-Round(IIf(IsNull([Total Billed]),0,[Total Billed]),2),2

Where Clause

((([Entrepreneur Company Principal Projects].[Monthly Allocated Amount]) Is Not

Order By

[Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company Programme Years].[Company Programme Year Status ID]

SQL

SELECT [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company Programme Years].[Entrepreneur Company ID], [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], [Entrepreneur Company Principal Projects].[Monthly Allocated Amount], Month([Date Status Changed]), Year([Date Status Changed]), [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], Month([Last Billing Date]), [Entrepreneur Company Principal Projects].[Lump Sum Allocation], Round(IIf(IsNull([Total Billed]),0,[Total Billed]),2), Round([Allocated Amount]-Round(IIf(IsNull([Total Billed]),0,[Total Billed]),2),2 FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Qry Get Last Billing Date by EP Company Principal Project], [Qry Sum Total Billed by Company PP and Project Pillar] WHERE ((([Entrepreneur Company Principal Projects].[Monthly Allocated Amount]) Is Not