Skip to main content

Subject Librarian Community: Collection Development

Subject Librarian Assignments

GOBI

Collection Development Documents

Access Report for Circulation and Browse Statistics

Use these instructions to run an Access Report to get circulation and browse statistics by item. 

Open the access document "eisreport.mdb" click "Query Design" under the "Create" tab. Then close whatever pop up opens, and hit the SQL button. Paste the below code into the query design. You will be prompted for a call number start and stop and for a location ID use 2 to get the circulating collection.

SELECT MFHD_MASTER.DISPLAY_CALL_NO, utf8to16([bib_text].[TITLE_BRIEF])
AS Title_Brief, utf8to16([bib_text].[AUTHOR]) AS Author,
utf8to16([bib_text].[PUBLISHER]) AS Publisher,
utf8to16([bib_text].[PUBLISHER_DATE]) AS Publisher_Date,
Sum(ITEM.HISTORICAL_CHARGES) AS SumOfHISTORICAL_CHARGES,
Sum(ITEM.HISTORICAL_BROWSES) AS SumOfHISTORICAL_BROWSES,
Max(ITEM_STATUS.ITEM_STATUS_DATE) AS MaxOfITEM_STATUS_DATE, ITEM_BARCODE.ITEM_BARCODE FROM (((((BIB_MFHD INNER JOIN BIB_TEXT ON BIB_MFHD.BIB_ID =
BIB_TEXT.BIB_ID) INNER JOIN MFHD_MASTER ON BIB_MFHD.MFHD_ID =
MFHD_MASTER.MFHD_ID) INNER JOIN MFHD_ITEM ON MFHD_MASTER.MFHD_ID =
MFHD_ITEM.MFHD_ID) INNER JOIN ITEM ON MFHD_ITEM.ITEM_ID = ITEM.ITEM_ID) INNER JOIN ITEM_STATUS ON ITEM.ITEM_ID = ITEM_STATUS.ITEM_ID) INNER JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID WHERE (((ITEM_BARCODE.BARCODE_STATUS)="1"))
GROUP BY MFHD_MASTER.DISPLAY_CALL_NO,
utf8to16([bib_text].[TITLE_BRIEF]), utf8to16([bib_text].[AUTHOR]), utf8to16([bib_text].[PUBLISHER]), utf8to16([bib_text].[PUBLISHER_DATE]),
ITEM_BARCODE.ITEM_BARCODE, utf8to16([mfhd_master].[NORMALIZED_CALL_NO]),
MFHD_MASTER.LOCATION_ID
HAVING (((MFHD_MASTER.DISPLAY_CALL_NO) Between [First call number in range (case sensitive)] And [Last call number in range + 1 digit (case
sensitive)]) AND ((MFHD_MASTER.LOCATION_ID)=[Location ID])) ORDER BY utf8to16([mfhd_master].[NORMALIZED_CALL_NO]);

Access Reports: informational and training materials from CARLI

Sudden Selector's Guide to...