Skip to content

Query: Qry Report Writer

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

Tables Referenced

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

Columns Selected

  • Proposal.[Proposal ID]
  • Proposal.[Date Created]
  • Principal
  • Proposal.[Proposal Status ID]
  • [Proposal Status].[Proposal Status]
  • Proposal.[Proposal Brief Completed]
  • Proposal.[Proposal Date Submitted]
  • Proposal.[Contract Type]
  • [Proposal Type of Document LkUp].[Proposal Type of Document]
  • \
  • \
  • \
  • Proposal.[Budget Amount]
  • Proposal.[Opportunity Owner]
  • \
  • \
  • [Delivery Locations Sales].[Delivery Location]
  • Proposal.[Tender Sourcing]
  • IIf(IsNull([Total Minutes]),0,[Total Minutes])
  • IIf(IsNull([Total Minutes]),0,Round([Total Minutes]/60,2))

Order By

Proposal.[Proposal ID]

SQL

SELECT Proposal.[Proposal ID], Proposal.[Date Created], [Principals Sales].Principal, Proposal.[Proposal Status ID], [Proposal Status].[Proposal Status], Proposal.[Proposal Brief Completed], Proposal.[Proposal Date Submitted], Proposal.[Contract Type], [Proposal Type of Document LkUp].[Proposal Type of Document], \, \, \, Proposal.[Budget Amount], Proposal.[Opportunity Owner], \, \, [Delivery Locations Sales].[Delivery Location], Proposal.[Tender Sourcing], IIf(IsNull([Total Minutes]),0,[Total Minutes]), IIf(IsNull([Total Minutes]),0,Round([Total Minutes]/60,2)) FROM [Proposal], [Principals Sales], [Proposal Status], [Proposal Type of Document LkUp], [Delivery Locations Sales], [Qry Sum Time Tracker Minutes by Proposal]