Can anyone help me with how to make a query to list all volunteers who worked more than 500 hours since 7/1/07?  Thanks for your help!

Hi Amy,

This has actually been filed as a suggestion under BB18208 but in the mean time the following workaround should get you the group of volunteers that you need.

You can get a constituent query of volunteers whose cumulative volunteer hours fall within a certain range by doing the following:

1. Open Reports, Volunteer Reports, Volunteer Summary, New Volunteer Summary
2. Indicate range (both values must be entered)
3. You can filter on Volunteer Types and Volunteer Statuses to include on the Filter tab
4. On the General Tab indicate option to 'Create output query'
5. Print or Print Preview and give the query a name

I hope that helps,

Naomi

Hi Naomi,

Thank you for the workaround!  Is there a way to limit this to hours worked since July 1st 2007?  I can't figure out how to do that. 

I also tried creating a query specifying both the date range and the 500-hour minimum.  But the query selected only individual records with more than 500 hours instead of using the total hours for the 15 month period.  So the reporting workaround handles the hour limit properly but not the date range and the query I developed handles the date range but not the hours.  Seems like there should be a way to do both.

Thanks again for all help!

    Amy

Hi Amy,

Unfortunately, I cannot find a way to filter any of the available functions by a date range in Raiser's Edge.  I was able to do so quite easily in Crystal by doing the following:

1. Based an export on a query that had grouped all of my volunteers and exported only timesheet hours for the timesheets that fell within a certain date range (don't have to specify how many because Blackbaud ReportWriter Database format is not a flat file)

2. In Crystal, I grouped by volunteer's name and dropped in the details from the timesheet.

3. I inserted a subtotal by volunteer and then used the filter function to include only those whose total was greater than or equal to a specific amount.

I hope that helps,

Naomi

Naomi,

Thank you so much -- that should do the trick.

Amy