Skip to content

Query: Qry Report Principal Spend Tracking

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

Tables Referenced

  • Submissions
  • Submissions Principal Spend
  • MonthLkUp

Columns Selected

  • [Submissions Principal Spend].[Entrepreneur Company Principal Project ID]
  • Submissions.[Submission Year]
  • Submissions.[Submission Month]
  • MonthLkUp.[Month Number]
  • Sum([Submissions Principal Spend].[Principal Spend])

Order By

[Submissions Principal Spend].[Entrepreneur Company Principal Project ID], Submissions.[Submission Year], MonthLkUp.[Month Number]

SQL

SELECT [Submissions Principal Spend].[Entrepreneur Company Principal Project ID], Submissions.[Submission Year], Submissions.[Submission Month], MonthLkUp.[Month Number], Sum([Submissions Principal Spend].[Principal Spend]) FROM [Submissions], [Submissions Principal Spend], [MonthLkUp]