Currently, if you use a query to export the hours logged by all volunteers, it becomes a million rows deep because it generates one row for each timesheet entry for each volunteer.
The ability to generate a query (separate from the volunteer performance summary reports) that can export a summation of all volunteer hours within particular dates, and generate one single row per volunteer constituent record would be immensely helpful.
Every month, we currently run 4 different volunteer performance summary reports and 1 volunteer-based query. We then copy and paste each of these into a master macro-enabled excel template so it can do some formulas we use to bestow and remove free memberships for our volunteers. The ability to run 1 volunteer-based query that gives us date-specific hour summations would be tremendously helpful.
Similar date-based summations would be applicable to query items that are monetarily-based, like paid memberships or paid tickets, etc.
-------------
Edit: I am aware you can use some formulas in numerical query items, but those are total formulas, adding date-based calculations is my specific request
Randall Rupert
| Customer references | Bok Tower Gardens |
