Skip to content

Query: Qry Sum Marketing Budget Principal Project

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

Tables Referenced

  • Marketing
  • Principal Projects
  • Marketing Campaigns

Columns Selected

  • Sum(IIf(IsNull([Standard Marketing Budget]),0,[Standard Marketing Budget])+IIf(I

Where Clause

((([Marketing Campaigns].[Marketing Campaign Status ID])=1))

SQL

SELECT Sum(IIf(IsNull([Standard Marketing Budget]),0,[Standard Marketing Budget])+IIf(I FROM [Marketing Campaigns], [Principal Projects] WHERE ((([Marketing Campaigns].[Marketing Campaign Status ID])=1))