You folks are awesome and your response time is phenomenal. Both solutions worked great and will be the foundations of many queries to come. I googled all over and could not find this solution...than ks for being here and for taking the time to help a novice!

Sincerely,
bpbull...

Awesome job! Greatly appreciated! Worked like a charm.

Thank You,
bpbull...

SQL Server 2003 - SQL Query Analyzer. We have a database that stores service tickets and a table called non_part_usage. In this table, we have one field called request_id, one field called line_code_type and one field called quantity (there are more, but these are all we need for this question). Each request_id represents a service ticket. We have two line code types: L for Labor and T for Travel. The quantity field is a number of hours. One...