Sum Data Based on Date Field

[Can5er]

Hello,

I have several related tables in my report, but need to add a calculation for several of the fields based on a date. The data includes a date as mm/dd/yyyy and then three additional fields with bonus payments, vacation hours and vacation payments. I want to be able to sum the bonus and vacation information by year. This is part of a much larger report that includes much information about specific employees over a three year period. The data I am trying to sum looks like this:

PPE Bonus_Pay Vac_Hrs Vac_Earn


1/10/09 1212.00 8 532
4/21/09 834.00 8 532

Similar entries for a three year period.

I tried grouping but the result tripled the summed numbers. I am a newbie and am certain it is operator error, but this operator is out of solutions. I appreciate any assistance.

[pbaldy]

How about a query:

SELECT Year(PPE) As YearOfData, Sum(Bonus_Pay) As TotalBonus, Sum(Vac_Hrs) As TotalVacHours, Sum(Vac_Earn) As TotalVacEarn
FROM TableName
GROUP BY Year(PPE)

[Can5er]

Thanks. I will try that approach, but "novice" does refer to my Access experience as well as my posting history.