Thank you very much for the assistance. After working with the query properly and comparing side by side your query worked perfectly.. Once again thank you... :hehe:

Since my table and data already existed I have been working with the query. At this point my result set based on the code help shows....

1 1 ...