Skip to content

Query: Qry Get Companies for Lump Sum Allocation

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company
  • Entrepreneurs

Columns Selected

  • [Entrepreneur Company].[Entrepreneur Company ID]
  • Entrepreneurs.[Recommended Principal Project ID]
  • Entrepreneurs.[Recommended Product ID]
  • [Entrepreneur Company].[Company Status ID]
  • Entrepreneurs.[Process Status ID]

Where Clause

(((Entrepreneurs.[Recommended Principal Project ID])=Forms![Frm Lump Sum Allocat

SQL

SELECT [Entrepreneur Company].[Entrepreneur Company ID], Entrepreneurs.[Recommended Principal Project ID], Entrepreneurs.[Recommended Product ID], [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Process Status ID] FROM [Entrepreneur Company], [Entrepreneurs] WHERE (((Entrepreneurs.[Recommended Principal Project ID])=Forms![Frm Lump Sum Allocat