Cindy,

Evan nailed it for you, the order of your order by is wrong, you want the Job_desc as the first order by and and the Rec as the second, ORDER BY 2,1