Good Day to All, I am organizing some Affirmative Action data and I need to be able to sum a number of field totals and then print them in a report. I have 5 tables that store the data that I need for this report:
1) tblMasterEmployee - relates the next 3 tables by EmployeeID
2) tblEmployeeDates - need Date of Hire and Termination Date (if applicable)
3) tblEEO-Promotions - Keeps track of employee promotions
4) tblEEO-EmployeeData - has the raw data needed for reports. It keeps data such as employees' race, position, job group, etc.
5) tblApplicationLog - I also need to keep track of applicants by race and gender, but this data is not related to the other fields, since an applicant does not mean that the person is employed.
The following is a snapshot of one page of the report.
[HTML]Job Group: 1 External Hires External Applicants Promotions- Into Promotions - Within
Job-Group Job-Group
Male Female Male Female Male Female Male Female
White
Black/African Am
Asian/Pacific Is
American Indian
Hispanic
Race Missing
Total
Job Group: 1 Voluntary Terminations Involuntary Terminations Layoffs Recalls
Male Female Male Female Male Female Male Female
White
Black/African Am
Asian/Pacific Is
American Indian
Hispanic
Race Missing
Total[/HTML]
The above form is printed for each of my 5 job groups. The challenge for me is to not only count each race, I need to break out the personnel activities (External Hires, Promotions, etc.), by male-female and race. All this is done by job group. So I need to create a report that does everything that I have tried to explain for 5 job groups, but depending on the size of the company, it could be for 25 job groups or more.
Much appreciation for anyone who can help me over this hurdle.
David
I am running Windows XP, Access 2002 in 2000 mode.