Skip to content

Query: Qry Report More Than 3 Follow Ups

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

Tables Referenced

  • SubQry Rpt More Than 3 Follow Ups Count
  • Lead Types
  • Entrepreneur Company
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]
  • [SubQry Rpt More Than 3 Follow Ups Count].[Number Follow Up]
  • Entrepreneurs.[Process Status ID]
  • Entrepreneurs.[Date Status Changed]
  • [Lead Types].[Lead Type]
  • Entrepreneurs.[Status Modified By]
  • [First Name] & \
  • [Entrepreneur Company].[Company Name]
  • Entrepreneurs.[Telephone Number]
  • OwnedBy

Where Clause

((([SubQry Rpt More Than 3 Follow Ups Count].[Number Follow Up])>3) And ((Entrep

Order By

[First Name] & \

SQL

SELECT Entrepreneurs.[Entrepreneur ID], [SubQry Rpt More Than 3 Follow Ups Count].[Number Follow Up], Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Status Changed], [Lead Types].[Lead Type], Entrepreneurs.[Status Modified By], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Telephone Number], Entrepreneurs.OwnedBy FROM [Entrepreneurs], [SubQry Rpt More Than 3 Follow Ups Count], [Entrepreneur Company], [Lead Types] WHERE ((([SubQry Rpt More Than 3 Follow Ups Count].[Number Follow Up])>3) And ((Entrep