BleepingComputer.com: Database Help

Hi there,

i'm new to databased so i apologise if this is really easy.

i have a database where i have a department in 1 field, member of staff in another and a grade in the 3rd (ranging from 1-4). How do i get a query to add the amount of 1's then 2's etc per department?

Thanks for any help
Phil

SELECT COUNT(grade)
FROM Department
WHERE Department = HR (for e.g.) AND grade = 1

I don't really get what you mean, so this query actually count the number of grade = 1 in HR department.

If I got you wrong, let me know and I can change accordingly.

could try

select department,grade, count(member of staff)
from tablename
group by department,grade

will give you result set like this (for example)

department grade count
hr 1 1
hr 2 2
hr 3 44

You'll need to get the column and table names right.

Good luck.