Hello, all! I have been trying to detect, isolate, and delete orphaned authority headings, i.e., authority records to which no record is attached. I tried adapting the duplicate authority record report from the SQL Reports Library. I thought changing this one line would do the trick, but alas, it did not. HAVING count(authid) > 1
I changed it to HAVING count(authid) < 1
HAVING count(authid) = 1 HAVING authid IS NULL OR authid = ''
Alas, an empty report. Is there something I can do to find and then delete the orphaned authority records? Many of these orphaned authority records are duplicates that I am painstakingly merging two at a time. If I could get some help in speeding up the merge and deletion because going through the records two at a time is terribly inefficient. Many thanks for your help. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.