Sort information in report summaries

[Fredgarner]

I have shareholders who buy shares in 3 currencies-£,$ and €. At the moment my report is doing totals per shareholder (in the Summary section), but how can I make it refine this further and sort the data into 3 areas- £,$ and €?

 

[AlexMidd]

Do you mean one transaction could be in Euros, and the next in Punds etc or are the transactions entered into the databse in one currency and you want totals converted into the other two currencies?

If the first option, is there a field which says which currency the transaction was in?

Have fun! )

Alex Middleton