Skip to content

Query: Qry Report Headhunting by Owned By

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

Tables Referenced

  • SubQry Rpt Headhunting Count Qualified by Owned By
  • SubQry
  • SubQry Rpt Headhunting Count Total by Owned By

Columns Selected

  • [SubQry Rpt Headhunting Count Total by Owned By].[Headhunted By]
  • [SubQry Rpt Headhunting Count Total by Owned By].[Total Headhunted]
  • IIf(IsNull([Total Qualified]),0,[Total Qualified])
  • [Tot Qualified]/[Total Headhunted]

Order By

[SubQry Rpt Headhunting Count Total by Owned By].[Headhunted By]

SQL

SELECT [SubQry Rpt Headhunting Count Total by Owned By].[Headhunted By], [SubQry Rpt Headhunting Count Total by Owned By].[Total Headhunted], IIf(IsNull([Total Qualified]),0,[Total Qualified]), [Tot Qualified]/[Total Headhunted] FROM [SubQry Rpt Headhunting Count Total by Owned By], [SubQry Rpt Headhunting Count Qualified by Owned By]