Skip to content

Query: Qry Get Principal Projects for Finance Audit Report

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

Tables Referenced

  • Qry
  • Qry Count Total Companies Allocated Lump Sum 1 Principal Project
  • Principal Projects
  • Qry Sum Total Spend by Principal Project
  • Principals

Columns Selected

  • [Principal] & \
  • [Principal Projects].[Principal Project ID]
  • IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje
  • [Qry Sum Total Spend by Principal Project].[Lump Sum Allocation]
  • [Qry Count Total Companies Allocated Lump Sum 1 Principal Project].[Total Compan

Where Clause

((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da

Order By

[Principal] & \

SQL

SELECT [Principal] & \, [Principal Projects].[Principal Project ID], IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje, [Qry Sum Total Spend by Principal Project].[Lump Sum Allocation], [Qry Count Total Companies Allocated Lump Sum 1 Principal Project].[Total Compan FROM [Qry Sum Total Spend by Principal Project], [Principal Projects], [Principals], [Qry Count Total Companies Allocated Lump Sum 1 Principal Project] WHERE ((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da