Skip to content

Query: Qry Get Entrepreneur Steps For Summary

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

Tables Referenced

  • SubQry
  • SubQry Get Entrepreneur Steps For Summary Criteria

Columns Selected

  • [SubQry Get Entrepreneur Steps For Summary Criteria].[Entrepreneur ID]
  • [SubQry Get Entrepreneur Steps For Summary Criteria].[Date Record Created]
  • [SubQry Get Entrepreneur Steps For Summary Criteria].[Step Number]
  • Max([SubQry Get Entrepreneur Steps For Summary Criteria].[Date Status Changed])

Order By

[SubQry Get Entrepreneur Steps For Summary Criteria].[Entrepreneur ID], [SubQry Get Entrepreneur Steps For Summary Criteria].[Step Number]

SQL

SELECT [SubQry Get Entrepreneur Steps For Summary Criteria].[Entrepreneur ID], [SubQry Get Entrepreneur Steps For Summary Criteria].[Date Record Created], [SubQry Get Entrepreneur Steps For Summary Criteria].[Step Number], Max([SubQry Get Entrepreneur Steps For Summary Criteria].[Date Status Changed]) FROM [SubQry Get Entrepreneur Steps For Summary Criteria]