relation: https://beta-documents.el-una.org/id/eprint/227/
title: Aleph Reports Combining SQL and Excel
creator: Thomas, Steve
subject: Aleph
description: Steve Thomas, Local Systems Development Coordinator, University of Tennessee.    This presentation will show how a few simple SQL scripts, when combined with the sort and compare features of Excel, may be used to prepare some powerful reports.  For example, in answer to a request for a report of duplicate holdings, the presenter was able to reduce the initial output file of over 69,000 book items into a report of less than 12,000 duplicate items by comparing call number and description data. 
date: 2009-05-08
type: Conference or Workshop Item
type: NonPeerReviewed
format: application/pdf
language: en
identifier: https://beta-documents.el-una.org/id/eprint/227/1/ELUNA_2009_A15a_ALL_Scripts.pdf
format: application/pdf
language: en
identifier: https://beta-documents.el-una.org/id/eprint/227/2/ELUNA_2009_A15a_Dup_Report_steps.pdf
format: application/pdf
language: en
identifier: https://beta-documents.el-una.org/id/eprint/227/3/ELUNA_2009_A15a_General_Excel_Tips.pdf
format: application/pdf
language: en
identifier: https://beta-documents.el-una.org/id/eprint/227/4/ELUNA_2009_A15a_Loan_Report_steps.pdf
format: application/pdf
language: en
identifier: https://beta-documents.el-una.org/id/eprint/227/5/ELUNA_2009_A15a_Periodicals_steps.pdf
format: application/pdf
language: en
identifier: https://beta-documents.el-una.org/id/eprint/227/6/ELUNA_2009_A15a_Premissions_steps.pdf
format: application/pdf
language: en
identifier: https://beta-documents.el-una.org/id/eprint/227/7/ELUNA_2009_A15a_Related_items_steps.pdf
identifier: Thomas, Steve (2009) Aleph Reports Combining SQL and Excel. In: ELUNA 2009, 6-8 May 2009, Richmond, Va..