>>>I've got this at the end of my SQL:
>>>
>>>ORDER BY metal, amount DESCENDING
>>>
>>>It puts it in order by metal, but not by amount. I have no idea why.
>>>
>>>Thanks,
>>>
>>>Michelle
>>
>>does the list look like
>>
>>"IRON", 10000
>>"IRON", 9000
>>"GOLD", 5000
>>"GOLD", 3000
>
>No, actually. I just realized that the metal (D,G,N) is in order ascending. The amount seems to be in random order.
>
>Thanks,
>
>Michelle

If you remove the word DESCENDING does that fix the problem? Can you list a sampling of what the order looks like?