Skip to content

Query: Qry Get Last Note Date by Entrepreneur

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

Tables Referenced

  • Entrepreneur Notes
  • Entrepreneur

Columns Selected

  • [Entrepreneur Notes].[Entrepreneur ID]
  • Max([Entrepreneur Notes].[Note Date])
  • Max([Entrepreneur Notes].[Entrepreneur Note ID])

SQL

SELECT [Entrepreneur Notes].[Entrepreneur ID], Max([Entrepreneur Notes].[Note Date]), Max([Entrepreneur Notes].[Entrepreneur Note ID]) FROM [Entrepreneur Notes]