Skip to content

Query: Qry Budget Spend Totals

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

Tables Referenced

  • Qry Sum Marketing Spend
  • Qry Sum Marketing Budget Principal Project
  • Qry
  • Qry Sum Marketing Budget Non Principal Project

Columns Selected

  • [Qry Sum Marketing Budget Non Principal Project].[Total Marketing Budget Non Pri
  • [Qry Sum Marketing Budget Principal Project].[Total Marketing Budget Principal P
  • IIf(IsNull([Total Marketing Budget Non Principal Project]),0,[Total Marketing Bu
  • [Qry Sum Marketing Spend].[Total Marketing Spend]
  • [Total Budget]-IIf(IsNull([Total Marketing Spend]),0,[Total Marketing Spend])

SQL

SELECT [Qry Sum Marketing Budget Non Principal Project].[Total Marketing Budget Non Pri, [Qry Sum Marketing Budget Principal Project].[Total Marketing Budget Principal P, IIf(IsNull([Total Marketing Budget Non Principal Project]),0,[Total Marketing Bu, [Qry Sum Marketing Spend].[Total Marketing Spend], [Total Budget]-IIf(IsNull([Total Marketing Spend]),0,[Total Marketing Spend]) FROM [Qry Sum Marketing Budget Non Principal Project], [Qry Sum Marketing Budget Principal Project], [Qry Sum Marketing Spend]