Count function

[SFCMatthews]

tableB is an one too many with tableA
One Item in tableB can have many items in tableA.
I need to count how many itemA in in tableA is related to itemB in tableB.
How many employees dose companyB have? I am trying to do this on a form. I have a company form with a sub form from the employees table. I would like a field on the company filed that tells me how many employees said company has.

 

[Catalina]

Look into the DCOUNT function, there are many examples on this forum.

Catalina

 

[SFCMatthews]

Ok thank you I have the first part completed and it works. It gives me the over all numbers, but now I need it broken down buy departments. any Ideas?
I have a CompanyTable, departmentTable, and EmployTable they are all part of the same form. I am trying to get the department numbers on the form. So when I pull up a department I know how many emploees are in that department.
I have added a textbox and put in =Dcount("employID","employtable") how do I tie it to the department I am looking at on the form. Right now it gives me the over all numbers.

 

[John Big Booty]

Check out the criteria portion of DCount() function.