Skip to content

Query: Qry Report Principal Spend by Principal and Company One Month

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company
  • Principal Project Pillars
  • Principals
  • Entrepreneur Company Programme Years
  • Principal Projects
  • Entrepreneur Company Principal Projects
  • Submissions
  • Submissions Principal Spend

Columns Selected

  • Submissions.[Submission Month]
  • Submissions.[Submission Year]
  • Principal
  • [Entrepreneur Company].[Company Name]
  • [Principal Project Pillars].[BBBEE Pillar]
  • [Entrepreneur Company Programme Years].[Contract Start Date]

Where Clause

(((Submissions.[Submission Month])=[Forms]![Frm Reports Month Year Dialog]![Subm

Order By

Principals.Principal, [Entrepreneur Company].[Company Name]

SQL

SELECT Submissions.[Submission Month], Submissions.[Submission Year], Principals.Principal, [Entrepreneur Company].[Company Name], [Principal Project Pillars].[BBBEE Pillar], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Entrepreneur Company Principal Projects], [Entrepreneur Company], [Submissions], [Submissions Principal Spend], [Principal Project Pillars], [Principal Projects], [Principals], [Entrepreneur Company Programme Years] WHERE (((Submissions.[Submission Month])=[Forms]![Frm Reports Month Year Dialog]![Subm