Need count of divisions and number of employees within division

[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

 

[laskowv]

Let me re-clarify. The form's datasource is the Division -- not the Company.

 

[laskowv]

Disregard below. The datasource is the COMPANY table.
Too many late nights.