Skip to content

Query: Qry Get Last Complete Submission ID by Company

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

Tables Referenced

  • Submissions
  • MonthLkUp

Columns Selected

  • Submissions.[Entrepreneur Company ID]
  • Submissions.[Submission Status ID]
  • Max(DateSerial([Submission Year],[Month Number],1))

SQL

SELECT Submissions.[Entrepreneur Company ID], Submissions.[Submission Status ID], Max(DateSerial([Submission Year],[Month Number],1)) FROM [Submissions], [MonthLkUp]