How to create a count expression?

[natyboi]

Hi i have a table named Employee having IDNo and a combobox named department with this row source
INST'L SERVICES DEPT.
FINANCE SERVICES DEPT.
TECHNICAL SERVICES DEPT.
OFFICE OF THE GM

the question is how can i create a count in each row source?

i already tried this code but it only shows #Error

here's the code ive tried:

=DCount("[IDNo]","Employee ","[department]='INST'L SERVICES DEPT.'")

[Luuk]

"DCOUNT()" ??? You are not using MS-Access!!!!

Or are you, than you are posting your question in the wrong place.

In mysql counting can be done using the function COUNT

[Luuk]

for the rest of this story see: this ;-)