David,

Thanks for your help.  I was taken off that project for awhile.  Now I am back on the project.  Life of a consultant.

I tried your solution and it works great...

I appreciate the fast response.

However, this does not answer the question.  These are methods I had already considered. 

The problem is that you will get one record per patient for...