Skip to content

Query: Qry Calculate Percent Headhunted Qualified by OwnedBy Date Range

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

Tables Referenced

  • Qry
  • Qry Count Headhunted Qualified by OwnedBy Date Range
  • Qry Count Headhunted by OwnedBy Date Range

Columns Selected

  • OwnedBy
  • IIf(IsNull([Total Headhunted]),0,[Total Headhunted])
  • IIf(IsNull([Headhunted Qualified]),0,[Headhunted Qualified])
  • IIf([Total HH]=0,0,IIf(IsNull([Headhunted Qualified]),0,[Headhunted Qualified])/

SQL

SELECT [Qry Count Headhunted by OwnedBy Date Range].OwnedBy, IIf(IsNull([Total Headhunted]),0,[Total Headhunted]), IIf(IsNull([Headhunted Qualified]),0,[Headhunted Qualified]), IIf([Total HH]=0,0,IIf(IsNull([Headhunted Qualified]),0,[Headhunted Qualified])/ FROM [Qry Count Headhunted by OwnedBy Date Range], [Qry Count Headhunted Qualified by OwnedBy Date Range]