Skip to content

Query: Qry Calcluate Extra Sponsor Element Amount Remaining

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

Tables Referenced

  • Qry Sum Extra Sponsor Element Allocated
  • Principal
  • Principal Project Pillars
  • Principal Projects
  • Principal Project Pillar Sponsor Elements
  • Principals

Columns Selected

  • [Principal Project Pillars].[Principal Project ID]
  • [Principal] & \
  • [Principal Project Pillar Sponsor Elements].[Principal Project Pillar Sponsor El
  • [Principal Project Pillar Sponsor Elements].[Element Type]
  • [Principal Project Pillar Sponsor Elements].[Frequency of Payments]
  • [Principal Project Pillar Sponsor Elements].[Payment Amount]
  • [Principal Project Pillar Sponsor Elements].[Sponsorship Amount]
  • IIf([Admin Fee]=0,[Sponsorship Amount],Int([Sponsorship Amount]/(1+[Admin Fee]))
  • IIf(IsNull([Total Allocated]),0,[Total Allocated])
  • [Sponsorship Available]-[Tot Allocated]

SQL

SELECT [Principal Project Pillars].[Principal Project ID], [Principal] & \, [Principal Project Pillar Sponsor Elements].[Principal Project Pillar Sponsor El, [Principal Project Pillar Sponsor Elements].[Element Type], [Principal Project Pillar Sponsor Elements].[Frequency of Payments], [Principal Project Pillar Sponsor Elements].[Payment Amount], [Principal Project Pillar Sponsor Elements].[Sponsorship Amount], IIf([Admin Fee]=0,[Sponsorship Amount],Int([Sponsorship Amount]/(1+[Admin Fee])), IIf(IsNull([Total Allocated]),0,[Total Allocated]), [Sponsorship Available]-[Tot Allocated] FROM [Principal Project Pillar Sponsor Elements], [Qry Sum Extra Sponsor Element Allocated], [Principal Project Pillars], [Principal Projects], [Principals]