800-222-9711

How to find Missing Information

More
5 years 9 months ago #604 by patrick20k
Queries in KLAS make it easy to find records that meet certain criteria. Unfortunately, it can be harder to search by what isn't there.

For example:
Maybe you want to find all of the books by a certain narrator that don't have the Foreign Accent subject heading.
Or maybe you want to find all of your patrons that are Active for cassettes but not for DB.

Computer logic is just not very good at that kind of thing... but there's still a way!

The attached HowTo has step-by-step instructions for comparing two sets of records in Excel, in order to find out which records are missing something. And of course: let us know if you need help!
Attachments:

Please Log in to join the conversation.

Time to create page: 0.039 seconds

KLAS Users - Keystone Systems, Inc. logo

Keystone Systems, Inc.
8016 Glenwood Ave., Suite 200
Raleigh, NC 27612
800-222-9711