running sum on query

Anon

This is for a attendence database.I have to keep track of the infractions occured by each individual employee on each day. With the infractions occured I have to create a running sum on a query so that when they hit a certain amount of points they are issued a certain type of warning which is to be printed out according to the point count..I want the running sum on the query so that I can pull it into the form because a running sum on a report prints the entire report and I only need the section pertaining to each individual employee. The person using the database after I create it does not want to scroll through the report to get to the employees which needs a warning issued then print the pages pertaining to the person.then print a warning page for the employee They want it where when the employee hits the warning status by entering the points received the cummulative value is totaled and shown on the form and then they have the option of printing a number of different warnings with information of the employee transfered to the form to print out...

iifs044

So ... is this the type of thing you're looking for?

SELECT EmployeeNumber,
COUNT(*) AS Infractions
FROM InfractionTable
GROUP BY EmployeeNumber
HAVING Infractions > MinimumWarningLevel

This should count the number of infractions in the InfractionTable table, and only return a list of those people having a total number of infractions more than MinimumWarningLevel.

tasistro

What dbase are you using?

Saludos
Gerardo

tasistro

Thanks mitch for the tip, I was doing it all wrong with where. Having was the cure. Thought subselects would be necesary

Saludos
Gerardo

Anon

WHAT I AM LOOKING FOR IS BASICALLY WHERE YOU HAVE THE EMPLOYEEID, DATE INFRACTION OCCURED ,PTS AND THEN I NEED THE SQL OR WAY OF GENERATING THE RUNNING SUM IN A CUMM PTS COLUMN...FOUR COLUMNS THAT i AM WORKING WITH THEN i HAVE A FIFTH WHERE i NEED TO ASSIGN A NUMBER 1,2,3,3-DAY SUSPENSION, AND TERMINATION ACCORDING TO WHAT THE RUNNING SUM OF THE CUMM PTS FIELD IS SHOWING FOR EACH EMPLOYEE. THIS WORKS FOR AN ENTIRE YEAR WITH POINTS DROPPING OFF AFTER THE TWELVE MONTH CYCLE. 30-34 IS 1, 35-39 IS 2 40-44 IS 3 45 TO 54 IS 3 DAY SUSPENSION AND 55 IS TERMINATION.

Anon

I have a different question and that is can anyone tell me how it is that if I have a form in viewing I can set the print range somehow to print only the part of the form that is showing in a report format. versus having to print the entire report to be able to print as an example...just the employee records that pertain to the employee....