Skip to content

Query: Qry Report Companies Assigned

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

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]
  • IIf([Own Bookkeeper]=True,\
  • [Qry Get Companies Not Non Graduate].[Date RC Bookkeeper Assigned]
  • [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]
  • [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID]
  • Submissions.[Submission Month]
  • [Submission Month] & \
  • 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], IIf([Own Bookkeeper]=True,\, [Qry Get Companies Not Non Graduate].[Date RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], Submissions.[Submission Month], [Submission Month] & \, IIf(IsNull([Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(\ FROM [Delivery Locations], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp], [Qry Get Companies Not Non Graduate]