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!!! 1
Display Number of Employees 4
Populate fields in one table from another tables using pop up form 2
Count 1
How do I query companies not having members w/certain level of mgm 5
Other table design solutions for storing multiple employee ID's 3
Ledger for Individual Customers 3
Getting another employee's data from the Employee table, and text innumber fields 3

Top