Skip to content

Query: Qry SubRpt BEE Certificate Blank

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

Tables Referenced

  • Product Divisions
  • CompanyStatus
  • Divisions
  • Entrepreneur Company
  • ProcessStatus
  • Entrepreneurs
  • Qry Get Current Contract Info by Company

Columns Selected

  • Entrepreneurs.[Process Status ID]
  • [Entrepreneur Company].[Company Status ID]
  • Entrepreneurs.[Delivery Location ID]
  • [First Name] & \
  • [Entrepreneur Company].[Company Name]
  • Division
  • Product
  • IIf(IsNull([Entrepreneur Company].[Company Status ID]),[ProcessStatus].[Status],
  • [Product Divisions].[BEE Certificate Required]
  • [Entrepreneur Company].[BEE Certificate Expire Date]

Where Clause

(((Entrepreneurs.[Process Status ID])<>41 And (Entrepreneurs.[Process Status ID]

Order By

[Qry Get Current Contract Info by Company].Product

SQL

SELECT Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Delivery Location ID], [First Name] & \, [Entrepreneur Company].[Company Name], Divisions.Division, [Qry Get Current Contract Info by Company].Product, IIf(IsNull([Entrepreneur Company].[Company Status ID]),[ProcessStatus].[Status],, [Product Divisions].[BEE Certificate Required], [Entrepreneur Company].[BEE Certificate Expire Date] FROM [Entrepreneurs], [Entrepreneur Company], [ProcessStatus], [Product Divisions], [Divisions], [Qry Get Current Contract Info by Company], [CompanyStatus] WHERE (((Entrepreneurs.[Process Status ID])<>41 And (Entrepreneurs.[Process Status ID]