Skip to content

Query: Qry Count Headhunted Qualified by OwnedBy Date Range

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

Tables Referenced

  • SubQry
  • SubQry Count Headhunted by OwnedBy Date Range Criteria

Columns Selected

  • OwnedBy
  • Count([SubQry Count Headhunted by OwnedBy Date Range Criteria].[Entrepreneur ID]

Where Clause

((([SubQry Count Headhunted by OwnedBy Date Range Criteria].[Step Number])>=2))

SQL

SELECT [SubQry Count Headhunted by OwnedBy Date Range Criteria].OwnedBy, Count([SubQry Count Headhunted by OwnedBy Date Range Criteria].[Entrepreneur ID] FROM [SubQry Count Headhunted by OwnedBy Date Range Criteria] WHERE ((([SubQry Count Headhunted by OwnedBy Date Range Criteria].[Step Number])>=2))