Skip to content

Query: Qry Count Entrepreneur Moved Last Week Digitalby Delivery Loca

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

Tables Referenced

  • SubQry Get Entrepreneur Moved Last Week
  • SubQry

Columns Selected

  • [SubQry Get Entrepreneur Moved Last Week].[Delivery Location ID]
  • [SubQry Get Entrepreneur Moved Last Week].[Delivery Location]
  • Count([SubQry Get Entrepreneur Moved Last Week].[Entrepreneur ID])

Where Clause

((([SubQry Get Entrepreneur Moved Last Week].[Selection Type])=2))

SQL

SELECT [SubQry Get Entrepreneur Moved Last Week].[Delivery Location ID], [SubQry Get Entrepreneur Moved Last Week].[Delivery Location], Count([SubQry Get Entrepreneur Moved Last Week].[Entrepreneur ID]) FROM [SubQry Get Entrepreneur Moved Last Week] WHERE ((([SubQry Get Entrepreneur Moved Last Week].[Selection Type])=2))