Yes, I can access the files and create a file of employee id number to compare outside of SQL. I was hoping for a solution that Report Manager based so our security staff could run the report at any time and see who does not have a badge.