Skip to content

Query: Qry Report Proposal TAT Non Standard

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

Tables Referenced

  • Qry Sum Time Tracker Minutes by Proposal
  • Principals Sales
  • Principals
  • Proposal
  • Proposal Status
  • Proposal Type of Document LkUp

Columns Selected

  • Proposal.[Proposal ID]
  • Proposal.[Date Created]
  • Proposal.[Proposal Status ID]
  • Proposal.[Proposal Type of Document ID]
  • [Proposal Type of Document LkUp].[Proposal Type of Document]
  • Principal
  • Proposal.[Proposal Brief Completed]
  • Proposal.[Proposal Due Date]
  • Proposal.[Proposal Date Submitted]
  • IIf(IsNull([Proposal Brief Completed]) Or IsNull([Proposal Date Submitted]),Null
  • [Proposal Type of Document LkUp].[Proposal Max TAT]
  • [Proposal Max TAT]-[Actual TAT]
  • IIf([Proposal Date Submitted]=[Proposal Due Date],\
  • Proposal.[Opportunity Owner]
  • Proposal.[Proposal Turnaround Time Comments]
  • IIf(IsNull([Total Minutes]),0,[Total Minutes])
  • IIf(IsNull([Total Minutes]),0,IIf([Total Minutes]<60,[Total Minutes] & \

Where Clause

(((Proposal.[Proposal Status ID])=8 Or (Proposal.[Proposal Status ID])=9 Or (Pro

Order By

[Proposal Type of Document LkUp].[Proposal Type of Document], [Principals Sales].Principal

SQL

SELECT Proposal.[Proposal ID], Proposal.[Date Created], Proposal.[Proposal Status ID], Proposal.[Proposal Type of Document ID], [Proposal Type of Document LkUp].[Proposal Type of Document], [Principals Sales].Principal, Proposal.[Proposal Brief Completed], Proposal.[Proposal Due Date], Proposal.[Proposal Date Submitted], IIf(IsNull([Proposal Brief Completed]) Or IsNull([Proposal Date Submitted]),Null, [Proposal Type of Document LkUp].[Proposal Max TAT], [Proposal Max TAT]-[Actual TAT], IIf([Proposal Date Submitted]=[Proposal Due Date],\, Proposal.[Opportunity Owner], Proposal.[Proposal Turnaround Time Comments], IIf(IsNull([Total Minutes]),0,[Total Minutes]), IIf(IsNull([Total Minutes]),0,IIf([Total Minutes]<60,[Total Minutes] & \ FROM [Principals Sales], [Proposal], [Proposal Status], [Proposal Type of Document LkUp], [Qry Sum Time Tracker Minutes by Proposal] WHERE (((Proposal.[Proposal Status ID])=8 Or (Proposal.[Proposal Status ID])=9 Or (Pro