Extracting data of different Depts from a table

  • Thread starter Thread starter Azhar Qureshi
  • Start date Start date
A

Azhar Qureshi

Hello. I have a table containing recds from 4 different depts say A B C and
D. I want to count the total records for each dept individually. Can i use a
query which returns A has 4 records B has 7 recds and so on.
 
Sure.

In SQL view, try:

SELECT dept, COUNT(*)
FROM tableNameHere
GROUP BY dept


where dept has to be changed by the real name for you field.


Vanderghast, Access MVP
 
Back
Top