Skip to content

Query: Qry Get Companies Assigned Both Bookkeepers

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
  • Submissions
  • Qry

Columns Selected

  • [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID]
  • [Qry Get Companies Not Non Graduate].[Company Status ID]
  • [Delivery Locations].[Delivery Location]
  • [Qry Get Companies Not Non Graduate].[Company Delivery Location ID]
  • [Qry Get Companies Not Non Graduate].[Company Name]
  • [Qry Get Companies Not Non Graduate].[Own Bookkeeper]
  • [Qry Get Companies Not Non Graduate].[Date RC Bookkeeper Assigned]
  • [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]
  • IIf(IsNull([Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(\

Order By

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

SQL

SELECT [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], [Qry Get Companies Not Non Graduate].[Company Status ID], [Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[Company Delivery Location ID], [Qry Get Companies Not Non Graduate].[Company Name], [Qry Get Companies Not Non Graduate].[Own Bookkeeper], [Qry Get Companies Not Non Graduate].[Date RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], IIf(IsNull([Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(\ FROM [Qry Get Companies Not Non Graduate], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp], [Delivery Locations]