This is enough to make my head swim.
It would appear you are trying to get a list of all accidents combined with
a total number of accidents.

--------------------------------------------------individual accidents
[tbl EmpAccidents].[tbl EmpAccidentsID],
[tbl EmpAccidents].EmployeeID,
[tbl EmpAccidents].FirstName,
[tbl EmpAccidents].LastName,
[tbl EmpAccidents].JobTitle,
[tbl EmpAccidents].Address,
[tbl EmpAccidents].City,
[tbl EmpAccidents].Zipcode,
[tbl EmpAccidents].DOB,
[tbl Accidents].AccidentDate,
[tbl Accidents].AccidentType,
[tbl Accidents].[Date of Injury],
[tbl Accidents].[Time of Injury],
[tbl Accidents].[Location of accident],
[tbl Accidents].[Time work began],
[tbl Accidents].[Date employer notified],
[tbl Accidents].Summary,
[tbl Accidents].[Physician/Hospital],
[tbl Accidents].[Physician/Hospital Address],
[tbl Accidents].[No treatment],
[tbl Accidents].[Minor:by employee],
[tbl Accidents].[Minor:clinic/hospital],
[tbl Accidents].[Emergency care],
[tbl Accidents].[Hospitalized>24 hrs],
[tbl Accidents].PointsAssigned,
[tbl Accidents].[Report prepared by],
[tbl Accidents].Position,
[tbl Accidents].Telephone,
[tbl Accidents].[Date of Report],
[tbl Body Parts].[Part of body affected],
[tbl CoDepartments].DepartmentName,

'----------------------------------------accident summary
[tbl Total Accidents].TotalbyEmp,
[tbl Total Accidents].TotalbyDept,
[tbl Total Accidents].TotDrivingPoints,
[tbl Total Accidents].Total
'---------------------------------------------------

If I understand your comments correctly, the TotalbyEmp, etc. are not
correct.

So how are you generating the [tblTotalAccidents] and what is the key field
for it?
It appears to contain rows like

[EmployeeTotalAccidents]    [DepartmentTotalAccidents] and [TotalAccidents]
which logically would not go together.

I would not use a table but a set of queries.

qryTotalbyEmp :

SELECT [EmployeeID], Count([EmpAccidentID) AS TotEmpAccidents
FROM [EmpAccidents]
GROUP BY [EmployeeID];

This will provide a set of data like
EmployeeID    TotEmpAccidents
1        3
2        1
3        0
4        2
--------------
a similar query is required for getting the number of accidents for a
department

Select [DepartmentID], Count([EmpAccidentID]) as TotDeptAccidents
From [EmpAccidents]
Group By [DepartmentID];

Then to get the final total of all accidents

Select Count[EmpAccidentID] as TotdepTaccidents
From [EmpAccidents];
(this should return only one number, the total count of accidents.

Ed Warren.