Need count of divisions and number of employees within division

L

laskowv

I have 3 tables: Company, Division, and Employee:

Company
CompanyID PK

Division
DivisionID PK
CompanyID FK
Divname
....other fields

Employee
DivisionID FK
LastName
....otherfields

I have Form whose data source is Company. I would like to have 2 display
fields for each company on the form showing:
1) Total Number of Divisions
2) Total Number of Employees for the Division

Are queries needed or can this "DCOUNT" function work? I've been trying to
read up on it.

Thanks...Valerie
 

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

Coding HELP!!! 4
Table Design 5
The Biggest Design Problem - HELPPPPP! 4
Display Number of Employees 4
Populate fields in one table from another tables using pop up form 5
Count 1
Creating an Employees' Training DB - Advice on Design 6
creating a table for accessing data via Access forms 5

Top