>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

select mySampTecField, cnt(*) ;
 from myTable ;
 group by mySampTecField

But I'm not sure I understood what you're trying to do. You might be reinventing the wheel (an XTab or PivotTable ?)
Cetin