Skip to content

Query: SubQry Rpt Tracker Count Current Submissions by Bookkeeper

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

Tables Referenced

  • Delivery Locations
  • Qry Get Companies Not Non Graduate
  • MonthLkUp
  • Submission Status
  • Submissions

Columns Selected

  • [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]
  • [Delivery Locations].[Delivery Location]
  • IIf([Own Bookkeeper]=True,\
  • Count(Submissions.[Entrepreneur Company ID])
  • Submissions.[Submission Year]
  • Submissions.[Submission Month]

Order By

[Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]

SQL

SELECT [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Delivery Locations].[Delivery Location], IIf([Own Bookkeeper]=True,\, Count(Submissions.[Entrepreneur Company ID]), Submissions.[Submission Year], Submissions.[Submission Month] FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate], [Delivery Locations]