multiple selects

[gogaak]

Hello all,
Multiple selects are not possible in Access..

I have a employee table who are categorized based on their division etc...
Division is a seperate table which enlists all the divisions and is linked to employee table by relationship table called Designation.

EMPLOYEE
*TokenID
Name
Location

DIVISION
*DivisionID
DivisionName

DESIGNATION
*Serial_no
TokenID
DivisionID
LevelID

The reason i have created a seperate table for division names, bcoz the division names can be updated.
How would I get data based on the count of employees in each division.

Any help would do..

 

[gogaak]

Oops its pretty easy..
Sorry for wasting your time..