AnsweredAssumed Answered

League Table

Question asked by crmorris2 on Oct 23, 2017
Latest reply on Oct 25, 2017 by philmodjunk

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