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
Neil Lewis
IT R&D Manager
Velmore Ltd