Skip to content

Query: Qry Report Team Activity Summary

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

Tables Referenced

  • Qry
  • Qry Report Team Activity Detail

Columns Selected

  • [Qry Report Team Activity Detail].[Status Modified By]
  • Job
  • [Qry Report Team Activity Detail].[Pay Point]
  • [Qry Report Team Activity Detail].[Position Effective Date]
  • [Qry Report Team Activity Detail].[Application Status]
  • [Qry Report Team Activity Detail].[Sort Order]
  • Count([Qry Report Team Activity Detail].[Application Status History ID])
  • Sum([Qry Report Team Activity Detail].[Time Unit])

Order By

[Qry Report Team Activity Detail].[Status Modified By], [Qry Report Team Activity Detail].Job, [Qry Report Team Activity Detail].[Pay Point], [Qry Report Team Activity Detail].[Position Effective Date], [Qry Report Team Activity Detail].[Sort Order]

SQL

SELECT [Qry Report Team Activity Detail].[Status Modified By], [Qry Report Team Activity Detail].Job, [Qry Report Team Activity Detail].[Pay Point], [Qry Report Team Activity Detail].[Position Effective Date], [Qry Report Team Activity Detail].[Application Status], [Qry Report Team Activity Detail].[Sort Order], Count([Qry Report Team Activity Detail].[Application Status History ID]), Sum([Qry Report Team Activity Detail].[Time Unit]) FROM [Qry Report Team Activity Detail]