Skip to content

Query: Qry Get Last Submission ID by Company

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

Tables Referenced

  • Submissions

Columns Selected

  • Submissions.[Entrepreneur Company ID]
  • Max(Submissions.[Submission ID])

SQL

SELECT Submissions.[Entrepreneur Company ID], Max(Submissions.[Submission ID]) FROM [Submissions]