Skip to content

Query: Qry Sum Marketing Budget Non Principal Project

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

Tables Referenced

  • Marketing Budget Non Principal Project
  • Marketing

Columns Selected

  • Sum([Marketing Budget Non Principal Project].[Budget Amount])

Where Clause

((([Marketing Budget Non Principal Project].[Marketing Budget Status ID])=1))

SQL

SELECT Sum([Marketing Budget Non Principal Project].[Budget Amount]) FROM [Marketing Budget Non Principal Project] WHERE ((([Marketing Budget Non Principal Project].[Marketing Budget Status ID])=1))