Skip to content

Query: Qry Sales Briefs Not Through Gateway

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

Tables Referenced

  • Sales
  • Sales Brief
  • Principals Sales

Columns Selected

  • [Sales Brief].[Sales Brief ID]
  • [Sales Brief].[Sales Brief Status ID]
  • [Sales Brief].[Been Through Gateway]
  • [Principal] & IIf(Not IsNull([Project]),\
  • [Sales Brief].[Sales Brief Number]
  • [Sales Brief].[Version Number]
  • [Sales Brief].[Solutions Architect]
  • Project

Where Clause

((([Sales Brief].[Sales Brief Status ID])=5) AND (([Sales Brief].[Been Through G

SQL

SELECT [Sales Brief].[Sales Brief ID], [Sales Brief].[Sales Brief Status ID], [Sales Brief].[Been Through Gateway], [Principal] & IIf(Not IsNull([Project]),\, [Sales Brief].[Sales Brief Number], [Sales Brief].[Version Number], [Sales Brief].[Solutions Architect], [Sales Brief].Project FROM [Sales Brief], [Principals Sales] WHERE ((([Sales Brief].[Sales Brief Status ID])=5) AND (([Sales Brief].[Been Through G