Skip to content

Query: Qry Company Submission List

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

Tables Referenced

  • vwAmberCompanySubmissionList
  • MonthLkUp

Columns Selected

  • vwAmberCompanySubmissionList.[Company Programme Year Status ID]
  • vwAmberCompanySubmissionList.[Company Status ID]
  • vwAmberCompanySubmissionList.[Entrepreneur Company ID]
  • vwAmberCompanySubmissionList.[Company Name]
  • vwAmberCompanySubmissionList.[Programme Year]
  • Product
  • vwAmberCompanySubmissionList.[Delivery Location]
  • vwAmberCompanySubmissionList.[RC Bookkeeper Assigned]
  • IIf([Own Bookkeeper]=True,\
  • vwAmberCompanySubmissionList.[Last Ignition Date]
  • IIf(Not IsNull([Last Status Change]),DateDiff(\
  • IIf(IsNull([Last Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(
  • IIf(IsNull([Last Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(

SQL

SELECT vwAmberCompanySubmissionList.[Company Programme Year Status ID], vwAmberCompanySubmissionList.[Company Status ID], vwAmberCompanySubmissionList.[Entrepreneur Company ID], vwAmberCompanySubmissionList.[Company Name], vwAmberCompanySubmissionList.[Programme Year], vwAmberCompanySubmissionList.Product, vwAmberCompanySubmissionList.[Delivery Location], vwAmberCompanySubmissionList.[RC Bookkeeper Assigned], IIf([Own Bookkeeper]=True,\, vwAmberCompanySubmissionList.[Last Ignition Date], IIf(Not IsNull([Last Status Change]),DateDiff(\, IIf(IsNull([Last Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(, IIf(IsNull([Last Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd( FROM [MonthLkUp], [vwAmberCompanySubmissionList]