Summary... By Criteria

[life036]

Hello All,

I've got a database that tracks volunteer information and a related table that tracks the hours the volunteers put in. Each record in the related table only tracks the Year, Month, and how many hours they put in for that month (no date fields involved, strictly text and number).

I'm trying to get a summary of all the hours they put in every year, except it always calculates all of the years... How can I get a sum of just the hours from 2006?

Any ideas would be much appreciated!

Thanks,

Chris

[mr_vodka]

You can do a find for the year and then run a summary report grouped by VolunteerID.