Jump to content
Sign in to follow this  
life036

Summarizing... I think.

Recommended Posts

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 Department, Month, and how many hours they put in for that month (no date fields involved, strictly text and number).

How can I summarize all of the hours for all volunteers (separately and all together), and also split up by which department the hours were for?

I'm so confused, I don't know where to start!

Thanks,

Chris

Share this post


Link to post
Share on other sites

You would want to do this in the tracking file. Create subsummary reports and group it by department and volunteerID.

Share this post


Link to post
Share on other sites

Create a new layout based in the Hours file, change it to a List View layout. On the layout, add parts for Sub-Summary by Department and Trailing Grand Summary. Then add a field definition for a summary Total of Hours. Insert that field on the Sub-Summary and Training Grand Summary. If you want to show the detail Hours for each Month, leave the body part on there (shrink it to one line) and add the summary Total, otherwise remove the whole Body part entirely. Put the Department field on the Department part. Put your labels on the Header.

When the records in the found set are sorted by Department, the sub-summary parts will show in Preview Mode and printouts.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.