Skip to content

Query: Qry Get Last Month Principal Spend YTD

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company
  • MonthLkUp
  • Submissions
  • Submissions Principal Spend

Columns Selected

  • Submissions.[Submission Year]
  • Max(MonthLkUp.[Month Number])

Where Clause

((([Submissions Principal Spend].[Principal Spend]) Is Not Null))

SQL

SELECT Submissions.[Submission Year], Max(MonthLkUp.[Month Number]) FROM [Entrepreneur Company], [Submissions], [Submissions Principal Spend], [MonthLkUp] WHERE ((([Submissions Principal Spend].[Principal Spend]) Is Not Null))