Skip to content

Query: Qry Count Companies Assigned by Bookkeeper

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

Tables Referenced

  • Qry Report Companies Assigned
  • Qry

Columns Selected

  • [Qry Report Companies Assigned].[Delivery Location]
  • [Qry Report Companies Assigned].[RC Bookkeeper Assigned]
  • [Qry Report Companies Assigned].[Their Own Bookkeeper]
  • Count([Qry Report Companies Assigned].[Entrepreneur Company ID])

Order By

[Qry Report Companies Assigned].[RC Bookkeeper Assigned]

SQL

SELECT [Qry Report Companies Assigned].[Delivery Location], [Qry Report Companies Assigned].[RC Bookkeeper Assigned], [Qry Report Companies Assigned].[Their Own Bookkeeper], Count([Qry Report Companies Assigned].[Entrepreneur Company ID]) FROM [Qry Report Companies Assigned]