Skip to content

Query: Backdoor Qry Company List

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company
  • Qry Get Last Complete Submission by Company

Columns Selected

  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company].[RC Bookkeeper Assigned]
  • IIf([Own Bookkeeper]=True,\
  • [Qry Get Last Complete Submission by Company].[Last Completed]

Order By

[Entrepreneur Company].[Entrepreneur Company ID]

SQL

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[RC Bookkeeper Assigned], IIf([Own Bookkeeper]=True,\, [Qry Get Last Complete Submission by Company].[Last Completed] FROM [Entrepreneur Company], [Qry Get Last Complete Submission by Company]