You didn't specify VFP version you're using. The ORDER BY that Boris used is only valid in VFP9. In earlier versions you have to use field position. Something like
ORDER BY 1,5,3
I'll live to you to do translation of field names to their positions.
>Tried and got ORDER by invalid clause. Without it, I got:
>23
>1078
>23
>1078
>1078
>1
>23
>1078
>not what I whish.
--sb--