Skip to content

Query: Qry Populate Temp Compliance by Company

Type: Delete
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 by Company
  • Submissions
  • Qry

Columns Selected

  • [Delivery Locations].[Delivery Location ID]
  • [Delivery Locations].[Delivery Location]
  • [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,\
  • SubmissionDate
  • [SubQry Rpt Bookkeeping Compliance by Company].[Submission Status]
  • [SubQry Rpt Bookkeeping Compliance by Company].[Issue New Permanent Staff]
  • [SubQry Rpt Bookkeeping Compliance by Company].[Issue YTD Does Not Match]

Where Clause

((([Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]) Is Not Null) A

Order By

[Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[Company Name], [SubQry Rpt Bookkeeping Compliance by Company].SubmissionDate

SQL

SELECT [Delivery Locations].[Delivery Location ID], [Delivery Locations].[Delivery Location], [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 by Company].SubmissionDate, [SubQry Rpt Bookkeeping Compliance by Company].[Submission Status], [SubQry Rpt Bookkeeping Compliance by Company].[Issue New Permanent Staff], [SubQry Rpt Bookkeeping Compliance by Company].[Issue YTD Does Not Match] FROM [Qry Get Companies Not Non Graduate], [Delivery Locations], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp], [SubQry Rpt Bookkeeping Compliance by Company] WHERE ((([Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]) Is Not Null) A