Cetin,

My SQL query works great now. Thankyou very much.

I now have a table name crsmatch with my results, can you give me any ideas of how I could count the number of samples and technicals and create a table with the results?

Thanks Cetin