LindaB59

Thanks to everyone who has responded... I have successfully installed and opened SQLiteSpy, opened my RM database, and copied in Tom's query.  However, when I tried to Execute the query, nothing happened.  I'm sure it is something I haven't done properly, but as someone with zero SQL experience, I cannot discern what that might be.  Any suggestions?  (Do I need to be selecting particular table/lists within my DB?)

Sadly, while I can download SQLLiteSPY fast and easy, it comes as a Zip file, and I don't have Winzip (and sure don't want to pay for it).   :-(

Thank you for the info, although I am very uneasy about running SQL queries, having never done so before.   (I'm baffled as to why such a fundamental component of our research is buried within the code.)   Is there no better way to uncover the citations?