Skip to content

Query: JB Qry Example of Report

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

Tables Referenced

  • ProcessStatus
  • Entrepreneurs
  • Pipelines

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]
  • Entrepreneurs.[Date Record Created]
  • Entrepreneurs.[Process Status ID]
  • Entrepreneurs.[Date Status Changed]
  • Status
  • ProcessStatus.[Sort Order]
  • Pipelines.[Selection Type]

Where Clause

(((Entrepreneurs.[Date Record Created])>=#9/25/2022# And (Entrepreneurs.[Date Re

Order By

Entrepreneurs.[Date Record Created]

SQL

SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Status Changed], ProcessStatus.Status, ProcessStatus.[Sort Order], Pipelines.[Selection Type] FROM [Entrepreneurs], [ProcessStatus], [Pipelines] WHERE (((Entrepreneurs.[Date Record Created])>=#9/25/2022# And (Entrepreneurs.[Date Re