eprintid: 632
rev_number: 17
eprint_status: archive
userid: 23
dir: disk0/00/00/06/32
datestamp: 2011-05-27 04:08:16
lastmod: 2016-06-09 20:42:59
status_changed: 2011-05-27 04:08:16
type: conference_item
metadata_visibility: show
item_issues_count: 0
creators_name: North, Michael
title: Access SQL Reporting FUNCTIONS  and the BLOB for Voyager
ispublished: pub
subjects: voyager
divisions: eluna_conf
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. 
date: 2011-05
date_type: published
full_text_status: restricted
pres_type: lecture
event_title: ELUNA 2011
event_location: Milwaukee, Wisconsin
event_dates: 11-13 May 2011
event_type: conference
refereed: FALSE
citation: North, Michael (2011) Access SQL Reporting FUNCTIONS and the BLOB for Voyager. In: ELUNA 2011, 11-13 May 2011, Milwaukee, Wisconsin.
document_url: https://beta-documents.el-una.org/id/eprint/632/1/Access_Functions_and_the_BLOB-North.pptx