Skip to content

Query: SubQry Rpt Tracker Count Current Complete Subs 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.[Submission ID])

Where Clause

(((Submissions.[Submission Year])=Forms![Frm Reports Month Year Dialog]![Submiss

SQL

SELECT [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Delivery Locations].[Delivery Location], IIf([Own Bookkeeper]=True,\, Count(Submissions.[Submission ID]) FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate], [Delivery Locations] WHERE (((Submissions.[Submission Year])=Forms![Frm Reports Month Year Dialog]![Submiss