Skip to content

Query: Qry Calculate Standard Marketing Budget by Sales Brief

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

Tables Referenced

  • Qry Sum Total Programme Fee by Sales Brief
  • Sales Brief
  • Qry

Columns Selected

  • [Qry Sum Total Programme Fee by Sales Brief].[Sales Brief ID]
  • [Qry Sum Total Programme Fee by Sales Brief].[Total Programme Fee]
  • [Sales Brief].[Sales Brief Status ID]
  • 024

Where Clause

((([Sales Brief].[Sales Brief Status ID])=1))

SQL

SELECT [Qry Sum Total Programme Fee by Sales Brief].[Sales Brief ID], [Qry Sum Total Programme Fee by Sales Brief].[Total Programme Fee], [Sales Brief].[Sales Brief Status ID], IIf(IsNull([Total Programme Fee]),0,[Total Programme Fee])*0.024 FROM [Qry Sum Total Programme Fee by Sales Brief], [Sales Brief] WHERE ((([Sales Brief].[Sales Brief Status ID])=1))