Sorting Amount By Currency

[hopia]

I wanted to sort all amounts by their respective currency.

Below is the output that i wanted.
AUD: xxx.xx
JPY: xxx.xx
SGD: xxx.xx
EUR: xxx.xx


I'm trying this code but it is not working. Hope you can help me to generate the output.

SELECT RefNumber, ProdCode, Amount, Currency,TraDate, AccOff
FROM tblSample
ORDER BY Currency

Thank you in advance.