Skip to content

Query: Qry Report Contract not Printed or VA Packs not Delivered

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

Tables Referenced

  • vwPurpleReportContractnotPrintedorVAPacksnotDelivered

Columns Selected

  • vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Entrepreneur ID]
  • [Principal] & \
  • OwnedBy
  • vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Process Status ID]
  • [First Name] & \
  • vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Company Name]
  • vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Company Status ID]
  • vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Date Contract Signed]
  • vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[VA Packs Delivered]

SQL

SELECT vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Entrepreneur ID], [Principal] & \, vwPurpleReportContractnotPrintedorVAPacksnotDelivered.OwnedBy, vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Process Status ID], [First Name] & \, vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Company Name], vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Company Status ID], vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Date Contract Signed], vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[VA Packs Delivered] FROM [vwPurpleReportContractnotPrintedorVAPacksnotDelivered]