Skip to content

Query: Qry Company List

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

Tables Referenced

  • MonthLkUp
  • vwAmberCompanyList

Columns Selected

  • vwAmberCompanyList.[Distribution Model ID]
  • vwAmberCompanyList.[Company Status ID]
  • vwAmberCompanyList.[Entrepreneur Company ID]
  • vwAmberCompanyList.[Company Name]
  • vwAmberCompanyList.[Programme Year]
  • Product
  • vwAmberCompanyList.[Delivery Location]
  • vwAmberCompanyList.[RC Bookkeeper Assigned]
  • IIf([Own Bookkeeper]=True,\
  • [Last Complete Submission Month] & \
  • vwAmberCompanyList.[Last Ignition Date]
  • 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 vwAmberCompanyList.[Distribution Model ID], vwAmberCompanyList.[Company Status ID], vwAmberCompanyList.[Entrepreneur Company ID], vwAmberCompanyList.[Company Name], vwAmberCompanyList.[Programme Year], vwAmberCompanyList.Product, vwAmberCompanyList.[Delivery Location], vwAmberCompanyList.[RC Bookkeeper Assigned], IIf([Own Bookkeeper]=True,\, [Last Complete Submission Month] & \, vwAmberCompanyList.[Last Ignition Date], 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 [vwAmberCompanyList], [MonthLkUp]