So I am working on a points tracking database. I have four table i use.
tblEmployee
EmployeeName
TeamName
NID
PID
DateofIncident
tblScoringPositive
PID
Pdescription
Ppoints
tblScoringNegative
NID
Ndescription
Npoints
The fourth table is a make table query which is made every time points are add for a real time static record of where the teams are point wise.
I have several queries and forms. I can track points at an employee level with description the problem is when i try to track them at a team level.
I have written several queries base off of the employee level data but cant seem to get all the points combined from all the different rows in the table and add up properly.
So a record looks like this
Employee ID EmployeeName TeamName NID PID DateofIncident
1 Doe,John Misfits 8 1 12/1/2017
2 smith,randy Dozens 1 7 12/2/2017
3 Doe,John Misfits 1 4 12/10/2017
So the ID's link back to a description and point value. One is suppose to equal zero but the zero doesn't seem to be getting enter into table.
So the problem is I cant figure out how together all these values and add them up when refer back to teams. Any help or changes will be meet with great appreciation.