We use a Microsoft Access database to compare A&I holdings.  One of the
"canned" queries in Access (find unmatched query wizard) compares two
tables (I use ISSN as the comparison) and returns all the titles in one
table that aren't in another.  The wizard runs you through all the steps
and works great - as long as the vendor data is great!

~~~~~~~~~~~~~~~~~~~~~~~~
Jenifer Holman
Acquisitions Librarian
Murphy Library
University of Wisconsin-La Crosse
1631 Pine St.
La Crosse, WI 54601

phone: 608-785-8395
fax: 608-785-8634
email: holman.jeni@uwlax.edu
http://www.uwlax.edu/murphylibrary/

-----Original Message-----
From: SERIALST: Serials in Libraries Discussion Forum
[mailto:SERIALST@LIST.UVM.EDU] On Behalf Of Marshall, Susan
Sent: Tuesday, May 11, 2004 12:46 PM
To: SERIALST@LIST.UVM.EDU
Subject: [SERIALST] A & I Database title overlap program?

Colleagues,

    I am trying to find out if there is a program available that will
run a
comparison of titles indexed between two index and abstract databases.
This can be used as a collection development tool. For example, we
would like to know what percentage of overlap occurs between
the Anthropological Index Online and InfoTrac's OneFile.

I realize that other factors need to be considered when camparing
databases of this nature such as how a database is indexed, but for
a rough estimate of overlap it would be nice to have...

Anyone know of a tool that can do this?

Sue Marshall
Electronic Resources Librarian
Renne Library
Montana State University
P.O. Box 173320
Bozeman, MT 59717-3320
smarshall@montana.edu
(406) 994-4313
Fax (406) 994-2851