Excellent, thank you very much for the help!!

The ID column is ascending and is auto generated when a person logs in or out of the office. 

You hit the nail on the head, I do just want the pairs...

Thanks, I'll give it a whirl.

Thanks guys. I was using VB to build the nested select dynamically but was hoping there was another way to do it. The data is in a table already which...

You can download practice exams from http://www.ucertify.com and/or http://www.preplogic.com. These both offer a limited amount of questions to test yourself with but you will have to pay for the...

All valid points. I have done a link to the QAS package we use, (ACE in the USA) which narrows it down. I guess that considering it's not the brightest...