I am creating a database for time and attendence.What I need to do is calculate
a field that will show the running sum of the infractions that occur. I
have the employee ID the Date and the points that are given for the severity
of the infraction. What I am looking for is a way that a query will show
in the fourth field which is Cumm Pts what the accumulated total running
is for each individual. so when you look at it in the form it shows how many
points they have recieved for a given period of time after you plug in the
points. I know you can do it on a report but I need the employees separated
for purpose of printing out what the individual has received. Any help will
be greatly appreciated!!!!!! This is an urgent matter.Thanks