Skip to content

Query: Qry SubRpt Lead Delivery Location by Lead Type

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

Tables Referenced

  • SubQry
  • SubQry Count Process Status by Lead Type Criteria

Columns Selected

  • Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID])
  • [SubQry Count Process Status by Lead Type Criteria].[Process Status ID]
  • [SubQry Count Process Status by Lead Type Criteria].[Delivery Location]

SQL

SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]), [SubQry Count Process Status by Lead Type Criteria].[Process Status ID], [SubQry Count Process Status by Lead Type Criteria].[Delivery Location] FROM [SubQry Count Process Status by Lead Type Criteria]