Counting records

[mjsabin]

Hey guys so I've been working with this huge data base. The tables consists of employee info such as salary, social security and so on. So the salary is paid through specific bonuses accounts depending on the position of the employee and i need a report showing the department to which they work and the amount of employees on each category(bonuses) and thats really the problem. Can i have access count this employees for me? And how can I do this i tried using Dcount and Count but im really not familiar Ive read a few articules on both of them but regardless of what i do is not working and I really need to get this done before the end of the week.

[RayMilhon]

The short answer is yes you can. How depends on your data structure and your requirements which are not stated.
but to give you an idea I'll use the following tables

tblEmployee
Employeeid Primary Key
name
dateofhire
terminationdate
departmentid Foreign Key to Department

tblDepartment
Departmentid Primary Key
Departmentdesc

Select Departmentdesc, Count(Employeeid)
From tblemployee inner join tbldepartment on tblemployee.departmentid = tbldepartment.departmentid
Where terminationdate is null
Group by departmentdesc