Skip to content

Query: SubQry Rpt Headhunting by Owned By Date Range Criteria

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

Tables Referenced

  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]
  • Entrepreneurs.[Headhunted By]
  • Entrepreneurs.[Process Status ID]

Where Clause

(((Entrepreneurs.[Headhunted By]) Is Not Null) And ((Entrepreneurs.[Date Record

SQL

SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Headhunted By], Entrepreneurs.[Process Status ID] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Headhunted By]) Is Not Null) And ((Entrepreneurs.[Date Record