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.

[img] Microsoft PowerPoint - Presentation
Restricted to Registered users only

1MB

Abstract

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
Subjects:Voyager
Divisions:ELUNA Conference Proceedings
ID Code:632
Deposited By: Marina Oliver
Deposited On:27 May 2011 04:08
Last Modified:09 Jun 2016 20:42

Repository Staff Only: item control page