Need Help!!!!!!

[Guest]

I am trying to create this database for injured employees. I have 35 injuries
an for each injuried I would like to get the total. For example if Bob, Lisa
and Sue all had head injuries my report should read 3 head injuries and so
forth. I am lost, I tried this but it does not work:
=Nz([countofhead], 0) + Nz([countofnose], 0) + Nz([countofmouth], 0) +
Nz([countofneck]) + Nz([countofr-eye]) + Nz([countofl-eye]) +
Nz([countofr-ear], 0) + Nz([countofl-ear], 0) + Nz([countofr-shoulder], 0) +
Nz([countofl-shoulder]) + Nz([countofupper back]) + Nz([countoflower back]) +
Nz([countofr-arm], 0) + Nz([countofl-arm], 0) + Nz([countofr-elbow], 0) +
Nz([countofl-elbow]) + Nz([countofr-wrist]) + Nz([countofl-wrist]) +
Nz([countofr-hand], 0) + Nz([countofl-hand], 0) + Nz([countofr-hip], 0) +
Nz([countofl-hip]) + Nz([countofstomach]) + Nz([countofgroin]) +
Nz([countofr-leg], 0) + Nz([countofl-leg], 0) + Nz([countofr-knee], 0) +
Nz([countofl-knee]) + Nz([countofr-ankle]) + Nz([countofl-ankle]) +
Nz([countofr-foot]) + Nz([countofl-foot]) + Nz([countoftoes]) +
Nz([countoffingers])
Sorry so big but please can someone help.

Thank you

 

[Duane Hookom]

I would not go any further with creating a solution until the tables had
been normalized. It looks like you are using data values as field names in a
table. I would recommend a structure similar to:

tblEmployees
=============
empEmpID
empLastName
....

tblInjuryTypes
=============
ityITyID autonumber primary key
ityInjury (values like eye, nose, mouth,...)

tblEmpInjuries
============
einEInID autonumber primary key
einEmpID link to tblEmployees
einITyID link to tblInjuryTypes
einDateOfInjury
einDateReported
einStatus