Count Records from Many Queries

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

I have an employee DB. From that, I run multiple queries
to find civilians, military, contractors, local national
employess. The separate queries find them by using pay
grade criteria. I would like to be able to run a query
(or report) that counts the number of civilians, military,
contractors so that at any given time, I can hit a query
or report called "Total Personnel By Type" and know how
many people I have by type without manually running each
of the established queries. I don't need names or any
other data, just how many of each type employee. Thank
you in advance.
 
Select EmployeeType, Count(EmployeeType) As CountOfTypes
From YourTable
Group By EmployeeType;
 
Back
Top