>>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