By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,025 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

How to create a count expression?

P: 15
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.'")
Nov 27 '14 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,032
"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
Nov 27 '14 #2

Expert 100+
P: 1,032
for the rest of this story see: this ;-)
Nov 27 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.