Cab, thanks for the comment on the SQL. I am glad to have a report that will help me keep an eye on permissions. FYI, I made a couple tweaks and added a second report that allows you to watch certain permissions (Permissions Check). While I was working on it, I found that the tools sub column wouldn't display all flags if most of them were turned on. Must be a limit in characters in each column. So I divided the tools column in two. I also found that the superlibrarian flag wasn't accurate when other flags were set. I fixed both issues in both SQL. ___________________________ Christopher Brannon IT Coordinator Coeur d'Alene Public Library 702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon@cdalibrary.org www.cdalibrary.org + peanut gallery commentary -- Whoa. Will have to spend some time learning from this lovely SQL ... Cheers, Cab Vinton Sanbornton PL Sanbornton, NH