Skip to content

Query: Qry Sum Total Application Status Times by Position

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

Tables Referenced

  • Application Status
  • Applications

Columns Selected

  • Applications.[Position ID]
  • Sum([Application Status].[Time Unit])

SQL

SELECT Applications.[Position ID], Sum([Application Status].[Time Unit]) FROM [Applications], [Application Status]