Skip to content

Query: Qry Report Partner Elite Summary

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

Tables Referenced

  • Qry Get Last Note by Entrepreneur
  • Entrepreneur Company
  • IndustryLookup
  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Division ID]
  • [First Name] & \
  • [Entrepreneur Company].[Company Name]
  • Industry
  • Status
  • [Qry Get Last Note by Entrepreneur].[Note Date]
  • Notes
  • ProcessStatus.[Step Number]

Where Clause

(((Entrepreneurs.[Division ID])=3) AND ((ProcessStatus.[Step Number])>=1 And (Pr

Order By

[First Name] & \, ProcessStatus.[Step Number]

SQL

SELECT Entrepreneurs.[Division ID], [First Name] & \, [Entrepreneur Company].[Company Name], IndustryLookup.Industry, ProcessStatus.Status, [Qry Get Last Note by Entrepreneur].[Note Date], [Qry Get Last Note by Entrepreneur].Notes, ProcessStatus.[Step Number] FROM [Entrepreneurs], [ProcessStatus], [Entrepreneur Company], [Qry Get Last Note by Entrepreneur], [IndustryLookup] WHERE (((Entrepreneurs.[Division ID])=3) AND ((ProcessStatus.[Step Number])>=1 And (Pr