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.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.061 seconds