Skip to content

Query: Qry Report Bookkeeping Compliance All Delivery Locations

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

Tables Referenced

  • Delivery Locations
  • Qry Get Companies Not Non Graduate
  • Qry Get Last Submission ID by Company
  • MonthLkUp
  • SubQry Rpt Bookkeeping Compliance All Delivery Locations
  • Submissions
  • Qry

Columns Selected

  • [Delivery Locations].[Delivery Location ID]
  • [Delivery Locations].[Delivery Location]
  • [Qry Get Companies Not Non Graduate].[Company Status ID]
  • IIf(IsNull([Submissions].[Submission Year]),Null,IIf(IsNull([Month Number]),Null
  • [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]
  • [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID]
  • [Qry Get Companies Not Non Graduate].[Company Name]
  • IIf([Own Bookkeeper]=True,\
  • [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Year]
  • [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Month]
  • [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Status]
  • [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Sort Order]
  • [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Days Since Change]
  • [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Date Status Changed]

Order By

[Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Company Name], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Sort Order]

SQL

SELECT [Delivery Locations].[Delivery Location ID], [Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[Company Status ID], IIf(IsNull([Submissions].[Submission Year]),Null,IIf(IsNull([Month Number]),Null, [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], [Qry Get Companies Not Non Graduate].[Company Name], IIf([Own Bookkeeper]=True,\, [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Year], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Month], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Status], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Sort Order], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Days Since Change], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Date Status Changed] FROM [Qry Get Companies Not Non Graduate], [SubQry Rpt Bookkeeping Compliance All Delivery Locations], [Delivery Locations], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp]