A merge query combined with Excel filters/sorts is your best bet to find records have "1 online resource" but not hour/minute info. Query A will find all the DB records with the cataloging MARC source of NLS that have an Alt Length that beings with "1 online...". Query B will find all the DB/NLS source titles that have the word "minutes" in the Alt Length. You could also search for "hours" but you should get more results with "minutes". Merge the queries to find the records that are only in the first set and not the second. Query A
BibRec - KLAS Id - Begins - DB
BibRec - Ttile Status - begins- A
BibRec - Alt Length - Begins - 1 online
BibRec - Cataloguing Source - Begins - NLSOpen results.Query B
BibRec - KLAS Id - Begins - DB
BibRec - Ttile Status - begins- A
BibRec - Alt Length - Matches - minutes
BibRec - Cataloguing Source - Begins - NLSOpen results.Merge Query In A Not B. This will include records that just have the word "hours" or a "minute" in the Alt Length. Export All Fields results to Excel and go to column BF and sort the Alt Length alphabetically or filter to find the titles that only have some variation of 1 online resource without hour(s)/minute(s) in parenthesis.
