ELUNA Document Repository

Access SQL Reporting FUNCTIONS and the BLOB for Voyager

North, Michael (2011) Access SQL Reporting FUNCTIONS and the BLOB for Voyager. In: ELUNA 2011, 11-13 May 2011, Milwaukee, Wisconsin.

[thumbnail of Access_Functions_and_the_BLOB-North.pptx] Microsoft PowerPoint - Presentation
Restricted to Registered users only



FUNCTIONS and the BLOB are important to Voyager reporting. Functions are small programs you add to Access SQL queries to enhance your ability to get data from Voyager. One example is for "date" related functions, which include Date(), DateAdd(), DatePart(), Now(), Time(), DateDiff() (and several more). Other useful functions (MID, LEFT, RIGHT) allow you to manipulate string data and to retrieve data that is part of a larger field of data (ie, "Method of Acquisition" value from the middle of the MFHD 008 tag). Finally, I will explain the BLOB is and how to use different BLOB functions to get information that is not part of a pre-defined field. This will enhance anyone's ability to pull useful data from Voyager for circulation, acquisitions, and statistics reports.

Item Type:Conference or Workshop Item (Lecture)
Event Title:ELUNA 2011
Divisions:ELUNA Conference Proceedings
ID Code:632
Deposited On:27 May 2011 04:08
Last Modified:09 Jun 2016 20:42

Repository Staff Only: item control page