...
Scope: The purpose of this Batch Stats Access database is to account for work done by LTS staff using Gary Strawn’s Location Changer and Record Reloader programs. Records altered using these programs are not given 948 field by which we can tally them in the TS Stats database. Appropriate staff members have been given individual “batch” log-ins to use when running Strawn software; these ID’s show up in the “Operator_ID” field in the Voyager tables. This database queries and reports this work, using these ID’s and other parts of the records. Please note that there is a query and report in the TS Stats database for those batch jobs which are processed using other tools and therefore contain 948 fields by which to count them. Together, the information from the two reports account for work done in batch form by LTS staff.
- Go to \\files.cornell.edu\LIB\ds-deptshares\tsstats and open the .mdb file called “3_BATCHstats.mdb.”
- At the right side of the screen, double-click on the macro called “1 – Batch BIB Summary Report.” (see below)
The following window will appear (below). Enter the starting and ending dates for the time period for which you wish to collect data.
If you haven’t already been in an Access database for Voyager during your computing session, Access will ask you for the VGR7 username and password. (see below)
The script will start to run a series of queries. When it is done, it will open the report containing the data for the date range you entered. (See next page for screenshot.) NOTE: If you want to save a copy of your report, you’ll need to right click on it and Export it as a PDF. If you or someone else runs the query before you’ve done that, your report will be overwritten and you will have to run it again (and export it immediately) in order to save the information it generated. Here's a sample report (below). Please see #6 to see an annotated version of it.
