Skip to content

Query: Qry Company List

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

Tables Referenced

  • vwGIACompanyList
  • Purple Panel Status Lookup
  • Purple Panels

Columns Selected

  • vwGIACompanyList.[Entrepreneur Company ID]
  • [Purple Panels].[Purple Panel ID]
  • vwGIACompanyList.[Company Status ID]
  • Status
  • vwGIACompanyList.[Last Process Status ID]
  • vwGIACompanyList.[Entrepreneur Status]
  • vwGIACompanyList.[Company Name]
  • vwGIACompanyList.[Delivery Location]
  • [Purple Panels].[Purple Panel Date]
  • Format([Purple Panel Time],\
  • [Purple Panels].[Average Score]
  • Passed

Where Clause

(((vwGIACompanyList.[Company Name]) Is Not Null))

SQL

SELECT vwGIACompanyList.[Entrepreneur Company ID], [Purple Panels].[Purple Panel ID], vwGIACompanyList.[Company Status ID], vwGIACompanyList.Status, vwGIACompanyList.[Last Process Status ID], vwGIACompanyList.[Entrepreneur Status], vwGIACompanyList.[Company Name], vwGIACompanyList.[Delivery Location], [Purple Panels].[Purple Panel Date], Format([Purple Panel Time],\, [Purple Panels].[Average Score], [Purple Panel Status Lookup].Passed FROM [vwGIACompanyList], [Purple Panels], [Purple Panel Status Lookup] WHERE (((vwGIACompanyList.[Company Name]) Is Not Null))