Skip to content

Query: SubQry Count Headhunted by OwnedBy Date Range Criteria

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

Tables Referenced

  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Date Record Created]
  • OwnedBy
  • Entrepreneurs.[Headhunted By]
  • Entrepreneurs.[Entrepreneur ID]
  • ProcessStatus.[Step Number]

Where Clause

(((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Selection Team Targets Rep

Order By

Entrepreneurs.[Entrepreneur ID]

SQL

SELECT Entrepreneurs.[Date Record Created], Entrepreneurs.OwnedBy, Entrepreneurs.[Headhunted By], Entrepreneurs.[Entrepreneur ID], ProcessStatus.[Step Number] FROM [Entrepreneurs], [ProcessStatus] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Selection Team Targets Rep