There was a request today for a Voyager report on a listserv. Here it is.

I'm trying to compare library usage from Fall 08 semester to Fall 09 semeseter. One of the things I'd like to do is show how many patrons checked items out of the library during that time period.

1. If the same patron checked items out on 5 DIFFERENT days during the month of January, I'd like to count that patron 5 times.
2. If the same patron checked out multiple items on the SAME day, I'd like to count that patron once for that day.

Does anyone have an access report that they use to show circulation usage that they could share?

I whipped up a quick report, but it doesn't run in MS Access. Instead, you must use sqlplus or any other Oracle driver. You can find the most up to date sql for it on GitHub. However, this is what I have as of this morning:

The general idea is to union the active transactions with the archived transactions. We also convert the charge date to a string of only its date (no time). This will allow the unique operation to remove duplicate patrons on any given day. We can then group by year, month, or date as configured.

Here is some sample output:

Please note that this report only works if you have elected to retain patron ids for circulation history. This is an option in the module SysAdmin > System > "Retain patron id for circ history".

I've done my best to make the report easy to modify by using variables instead of embedding magic numbers.

I'll be publishing all my Voyager reports to GitHub from now on in my voyager-reports repository. Feel free to fork it and send me pull requests any time you write your own.