Skip to content

Query: Qry Export Daily Lead Summary Leads More Than 48 Hours

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

Tables Referenced

  • Lead Types
  • Entrepreneur Company
  • ProcessStatus
  • Entrepreneurs
  • Delivery Locations

Columns Selected

  • [Lead Types].[Lead Type]
  • Entrepreneurs.[Date Record Created]
  • Entrepreneurs.[Date Status Changed]
  • [Entrepreneur Company].[Company Name]
  • [First Name] & \
  • Entrepreneurs.[Telephone Number]
  • Entrepreneurs.[Email Address]
  • Status
  • [Delivery Locations].[Delivery Location]
  • OwnedBy

Where Clause

(((Entrepreneurs.[Date Status Changed])<[Forms]![Frm Reports Single Date Dialog]

SQL

SELECT [Lead Types].[Lead Type], Entrepreneurs.[Date Record Created], Entrepreneurs.[Date Status Changed], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address], ProcessStatus.Status, [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[Date Status Changed])<[Forms]![Frm Reports Single Date Dialog]