Busy, busy, busy . . . I’m slowly and painfully working my way through Microsoft Access and SQL, and have the basic skill of modifying queries and building reports, but there’s a long way to go. The most immediate trick was to nudge one of the existing queries (the Bib-level "s" item data) to produce a dump of all serial level print holdings to include journal title, ISSN, and start and end dates. The data are intended for Serials Solutions so I can throw it into a spreadsheet and mail it to them to include that data to display in a print holdings section of our E-journal portal.
But, things being what they are and the fact that my PC takes a while to produce these reports coupled with the fact that the reference staff started alerting me to the fact that print holdings in the E-journal portal would be nice weeks ago, forced me to start a lot smaller than I’d have preferred. So, the data I sent the nice folks at SS only include holdings that match current E-Journal titles and ISSNs. That gets us started and buys some time to include additional upgrades over the next couple of months.
In the meantime, the 2006 Darwin Awards are out. It’s worth a look to remind ourselves that we as a species are not quite as smart as we like to think.
As Ezra says, I’m back to work.