Skip to content

Query: SubQry Get Last Complete Submission 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 ID]
  • DateSerial([Submission Year],[Month Number],1)

SQL

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