Calculating data for reports
I have created a sign-in / sign-out database for volunteers, which records the number of hours and activities completed each time they attend.
In the administration section of my database - I would like to have a reports page where I can see:
- the total number of hours completed by each volunteer for each activity between two set dates,
- the total number of hours completed by all volunteers for each activity between two set dates.
I'm not really sure how to go about doing this. The members list is in one table, the log of each sign in / sign out and activity completed is in another table, and the list of activities is in a 3rd table.
I'd really appreciate any help!