Skip to content

Query: Qry Report Raizcorp Possibilities

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

Tables Referenced

  • vwPurpleReportRaizcorpPossibilities
  • ProcessStatus

Columns Selected

  • vwPurpleReportRaizcorpPossibilities.[Date Status Changed]
  • DateDiff(\
  • vwPurpleReportRaizcorpPossibilities.[Company Status ID]
  • Status
  • Status
  • vwPurpleReportRaizcorpPossibilities.[Delivery Location]
  • Location
  • vwPurpleReportRaizcorpPossibilities.[Company Name]
  • [First Name] & \
  • vwPurpleReportRaizcorpPossibilities.[Telephone Number]
  • vwPurpleReportRaizcorpPossibilities.[Date of Birth]
  • Int(DateDiff(\
  • Gender
  • vwPurpleReportRaizcorpPossibilities.[Email Address]
  • Industry
  • vwPurpleReportRaizcorpPossibilities.[Brief Description of Business]
  • vwPurpleReportRaizcorpPossibilities.[Percentage Black Owned]
  • vwPurpleReportRaizcorpPossibilities.[Percentage Women Black Owned]
  • [Principal] & \
  • Product
  • IIf([Profile Created]=True,\
  • vwPurpleReportRaizcorpPossibilities.[Note Date]
  • Notes
  • vwPurpleReportRaizcorpPossibilities.[Product Pgm Yr]
  • vwPurpleReportRaizcorpPossibilities.[Date Pgm Yr Status Changed]

Order By

vwPurpleReportRaizcorpPossibilities.Status, vwPurpleReportRaizcorpPossibilities.[Delivery Location], vwPurpleReportRaizcorpPossibilities.[Company Name]

SQL

SELECT vwPurpleReportRaizcorpPossibilities.[Date Status Changed], DateDiff(\, vwPurpleReportRaizcorpPossibilities.[Company Status ID], vwPurpleReportRaizcorpPossibilities.Status, ProcessStatus.Status, vwPurpleReportRaizcorpPossibilities.[Delivery Location], vwPurpleReportRaizcorpPossibilities.Location, vwPurpleReportRaizcorpPossibilities.[Company Name], [First Name] & \, vwPurpleReportRaizcorpPossibilities.[Telephone Number], vwPurpleReportRaizcorpPossibilities.[Date of Birth], Int(DateDiff(\, vwPurpleReportRaizcorpPossibilities.Gender, vwPurpleReportRaizcorpPossibilities.[Email Address], vwPurpleReportRaizcorpPossibilities.Industry, vwPurpleReportRaizcorpPossibilities.[Brief Description of Business], vwPurpleReportRaizcorpPossibilities.[Percentage Black Owned], vwPurpleReportRaizcorpPossibilities.[Percentage Women Black Owned], [Principal] & \, vwPurpleReportRaizcorpPossibilities.Product, IIf([Profile Created]=True,\, vwPurpleReportRaizcorpPossibilities.[Note Date], vwPurpleReportRaizcorpPossibilities.Notes, vwPurpleReportRaizcorpPossibilities.[Product Pgm Yr], vwPurpleReportRaizcorpPossibilities.[Date Pgm Yr Status Changed] FROM [vwPurpleReportRaizcorpPossibilities], [ProcessStatus]