Skip to content

Raizcorp Technical Documentation

Query: Qry Get Principal Projects for Finance Report

Query: Qry Get Principal Projects for Finance Report

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

Tables Referenced

SubQry Get Principal Projects for Finance Report
Qry Sum Total Spend by Principal Project
Qry

Columns Selected

[SubQry Get Principal Projects for Finance Report].[Principal Project]
[SubQry Get Principal Projects for Finance Report].[Principal Project ID]
IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje

Order By

[SubQry Get Principal Projects for Finance Report].[Principal Project]

SQL

SELECT [SubQry Get Principal Projects for Finance Report].[Principal Project], [SubQry Get Principal Projects for Finance Report].[Principal Project ID], IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje FROM [Qry Sum Total Spend by Principal Project], [SubQry Get Principal Projects for Finance Report]