Need count of divisions and number of employees within division

  • Thread starter Thread starter laskowv
  • Start date Start date
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
 
Let me re-clarify. The form's datasource is the Division -- not the Company.
 
Disregard below. The datasource is the COMPANY table.
Too many late nights.
 
You must log in or register to reply here.

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
The Biggest Design Problem - HELPPPPP! 4
Populate fields in one table from another tables using pop up form 2
Other table design solutions for storing multiple employee ID's 3
Database design and adding new records 1
Display Number of Employees 4
Getting another employee's data from the Employee table, and text innumber fields 3
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top