Hi everyone, hope you can help, am a bit confused on this one.
I am trying to create a 'league table' where i have something similar to the below example....
1. UK 39
2. Spain 37
3. Ireland 20
4. Greece 18
5. Germany 10
So I have different data from 3 different tables. 'Joined course', 'country' and 'voucher code'.
They are all related so I really just need a table that only shows one instance of each country (instead of a long list) and then counts how many vouchers that country has used and then sorts the table by points.
I am an intermediate user but just can't work out the best way to do this.
Any help would be greatly appreciated
Thank you in advance