Skip to content

Query: Qry Report Part Sponsorship Entrepreneurs

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

Tables Referenced

  • vwPurpleReportPartSponsorshipEntrepreneurs

Columns Selected

  • vwPurpleReportPartSponsorshipEntrepreneurs.[Entrepreneur Company ID]
  • [First Name] & \
  • [Principal] & \
  • IIf([Profile Created]=True,\
  • Int(DateDiff(\
  • Gender
  • Location

SQL

SELECT vwPurpleReportPartSponsorshipEntrepreneurs.[Entrepreneur Company ID], [First Name] & \, [Principal] & \, IIf([Profile Created]=True,\, Int(DateDiff(\, vwPurpleReportPartSponsorshipEntrepreneurs.Gender, vwPurpleReportPartSponsorshipEntrepreneurs.Location FROM [vwPurpleReportPartSponsorshipEntrepreneurs]