Skip to content

Query: Qry Count Number Employees by Company

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

Tables Referenced

  • Applications
  • Positions

Columns Selected

  • Positions.[Company ID]
  • Positions.[Employment Status]
  • Count(Positions.[Position ID])

Where Clause

(((Positions.[Position Status ID])=4) AND ((Applications.[Application Status ID]

SQL

SELECT Positions.[Company ID], Positions.[Employment Status], Count(Positions.[Position ID]) FROM [Positions], [Applications] WHERE (((Positions.[Position Status ID])=4) AND ((Applications.[Application Status ID]