Skip to content

Query: Qry Entrepreneur Company Extra Sponsor Amount List

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

Tables Referenced

  • Qry Sum Extra Sponsor Element Payments by Company
  • Principal Project Pillars
  • Principal Projects
  • Entrepreneur Company Extra Sponsor Elements
  • Principal Project Pillar Sponsor Elements
  • Entrepreneur
  • Principals

Columns Selected

  • [Entrepreneur Company Extra Sponsor Elements].[Entrepreneur Company Extra Sponso
  • [Entrepreneur Company Extra Sponsor Elements].[Entrepreneur Company ID]
  • [Principal] & \
  • [Principal Project Pillar Sponsor Elements].[Element Type]
  • [Entrepreneur Company Extra Sponsor Elements].[Extra Sponsorship Amount]
  • IIf(IsNull([Total Paid]),0,[Total Paid])

SQL

SELECT [Entrepreneur Company Extra Sponsor Elements].[Entrepreneur Company Extra Sponso, [Entrepreneur Company Extra Sponsor Elements].[Entrepreneur Company ID], [Principal] & \, [Principal Project Pillar Sponsor Elements].[Element Type], [Entrepreneur Company Extra Sponsor Elements].[Extra Sponsorship Amount], IIf(IsNull([Total Paid]),0,[Total Paid]) FROM [Entrepreneur Company Extra Sponsor Elements], [Principal Project Pillar Sponsor Elements], [Principal Project Pillars], [Principal Projects], [Principals], [Qry Sum Extra Sponsor Element Payments by Company]