Skip to content

Query: Qry Report Selection Team Call Activity

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

Tables Referenced

  • SubQry Rpt Get Modified By
  • SubQry Rpt Count Unqualified by Modified By
  • SubQry
  • SubQry Rpt Count Followed Up by Modified By
  • SubQry Rpt Count First Meeting Setup by Modified By

Columns Selected

  • [SubQry Rpt Get Modified By].[Delivery Location]
  • [SubQry Rpt Get Modified By].[Status Modified By]
  • IIf(IsNull([Number of Unqualified]),0,[Number of Unqualified])
  • IIf(IsNull([Number of Followed Up]),0,[Number of Followed Up])
  • IIf(IsNull([Number of First Meeting Setup]),0,[Number of First Meeting Setup])
  • [# of Unqualified]+[# of Followed Up]+[# of First Meeting Setup]

SQL

SELECT [SubQry Rpt Get Modified By].[Delivery Location], [SubQry Rpt Get Modified By].[Status Modified By], IIf(IsNull([Number of Unqualified]),0,[Number of Unqualified]), IIf(IsNull([Number of Followed Up]),0,[Number of Followed Up]), IIf(IsNull([Number of First Meeting Setup]),0,[Number of First Meeting Setup]), [# of Unqualified]+[# of Followed Up]+[# of First Meeting Setup] FROM [SubQry Rpt Get Modified By], [SubQry Rpt Count Unqualified by Modified By], [SubQry Rpt Count Followed Up by Modified By], [SubQry Rpt Count First Meeting Setup by Modified By]