This is a sample from a payroll file I have to work with, it lists employee number, different types of earnings, & check date. The goal is to get a subtotal per employee that lists the employee's total wages and other earnings. I can't get my head around how to do this, can someone offer some suggestions? Some employees may have only one line, other employees may have lines with no regular wage types, only deductions/earnings (bonuses, insurance, etc...)
240 TN DP 800.00 1696.65 .00 .00 .00 .00 65 46.20 11/10/11
240 TN DP 800.00 1696.65 .00 .00 .00 .00 66 124.83 11/10/11
240 TN DP 800.00 1696.65 .00 .00 .00 .00 72 5.27 11/10/11
240 TN DP 800.00 1696.65 .00 .00 .00 .00 ZC 1933.75 11/10/11
240 TN DP 800.00 1643.55 .00 .00 .00 .00 65 46.20 11/25/11
240 TN DP 800.00 1643.55 .00 .00 .00 .00 66 122.18 11/25/11
240 TN DP 800.00 1643.55 .00 .00 .00 .00 72 5.27 11/25/11
240 TN DP 800.00 1643.55 .00 .00 .00 .00 ZC 1893.87 11/25/11
240 TN DP .00 .00 .00 .00 400.00 .00 66 20.00 12/09/11
240 TN DP 800.00 1595.25 .00 80.00 .00 .00 65 46.20 12/09/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 65 .00 07/08/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 67 .00 07/08/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 69 .00 07/08/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 72 .00 07/08/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 74 .00 07/08/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 ZC 1299.03 07/08/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 65 181.85 07/22/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 67 12.46 07/22/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 69 .00 07/22/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 72 22.15 07/22/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 74 .00 07/22/11
242 TN DP 1538.46 .00 .00 .00 .00 .00 ZC 1124.70 07/22/11