I am working on a volunteer database. I need to produce a report of hours worked by each volunteer on both a monthly and annual (total) basis. I am hoping to do this in a single report and have the ability to show all volunteer or a single volunteer in a format shown below.
Name Jan Feb Mar April……. Year to Date
John Doe 8 12 20
I have a table (work Log) which contains the volunteer's name, Month, Year, and an elapsed time calculation.