Count in ms access record...

[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.'")

[Seth Schrock]

What is the name of the field that the combobox Department is bound to?

[Rabbit]

You need to escape the single quote.