Skip to content

Query: Qry Get Principal Spend by Submission Date

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

Tables Referenced

  • Principal Project Pillars
  • MonthLkUp
  • Entrepreneur Company Principal Projects
  • Submissions
  • Submissions Principal Spend

Columns Selected

  • [Principal Project Pillars].[Principal Project ID]
  • Submissions.[Entrepreneur Company ID]
  • Submissions.[Submission Month]
  • Submissions.[Submission Year]
  • DateSerial([Submission Year],[Month Number],1)
  • [Submissions Principal Spend].[Principal Spend]

SQL

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