John,

That worked beautifully!!

Thanks.

Tony

Chris,

Yes it does!!!!!!!!

Thanks so much.  Now I just need to go through query to understand it and see how you came up with it. 

Thanks again.

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...