Query: Qry Get Last Status Change by Company
Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No
Tables Referenced
- Submissions
- Entrepreneur
- Entrepreneur Company
Columns Selected
- [Entrepreneur Company].[Entrepreneur Company ID]
- Max(Submissions.[Date Status Changed])
SQL
SELECT [Entrepreneur Company].[Entrepreneur Company ID], Max(Submissions.[Date Status Changed]) FROM [Entrepreneur Company], [Submissions]