Jim,

Thanks. My attempt at posting an example was poor and didn't show the real problem.

When I create cursors and fill in values (as I would to post an example) I can't reproduce the problem but when I use the real data it always comes out in the wrong order.

I'm thinking that FoxPro does something odd with the strings. It is totally strange, but since this particular report will only be used internally, I think I'll cut my losses and make a work-around.


>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