Skip to content

Query: Qry Sum Marketing Spend

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

Tables Referenced

  • Marketing Sub Campaigns
  • Marketing
  • Marketing Campaigns

Columns Selected

  • Sum([Marketing Sub Campaigns].[Marketing Sub Campaign Spend])

Where Clause

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

SQL

SELECT Sum([Marketing Sub Campaigns].[Marketing Sub Campaign Spend]) FROM [Marketing Sub Campaigns], [Marketing Campaigns] WHERE ((([Marketing Campaigns].[Marketing Campaign Status ID])=1))