Thanks for your reply.  My actual table is far more complex and I'm still working through the solution. However, it does seem to be working.  When you refered to "joins-SQL Server" were...