>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