how to count

Ù

ياسر

How to count names in the form or sub form:
For example:
If you have some Employees in Dept named 1 and others in Dept named 2
etc...
So how to count the names of the Employees in each Dept in unbound text box
in the form or report for each department like the following
Total Emp In dept 1 =
Total Emp in dept 2 =
etc..
Using access 2003
 
J

Jeff Boyce

Check the DCount() function in Access HELP for exact syntax...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To sort 3
Form using count function 7
Message based on Enrollment 1
Deduping with Linq / Where Exists 7
combobox data recognition? 1
"All" as a combo box option 21
forms autolookup 2
COUNT HELP 8

Top