much depends on how you want to present this data on the screen or printed page.
A summary report is one option and a "cross tab, also known as a "pivot table" report is also possible.
Of the two, a summary report is much easier to create.
Can you provided an example of how you want this to look?
Hi Thanks for looking at this. I work mainly on screen but once a week I would like to produce a PDF showing the weekly results. Below is a print screen with the matches in the first and second column. The third is the actual result (FC Augsburg vs B. Dortmund) 2:1 than we go into individual players. The first is Roli; he correctly picked 2:1 and gets 4 points etc etc.
Next week I open a new record, show (Column 1 and 2) the matches (dropdown menu) and so on it goes.
In the second screen print you will see Roli has 4 points from record 1 and record 2. In reality in the second week he only got 3 points.
So how do I get different results listed in that recap page. One way I figured is to build a field for each of the 34 game days (multiplied by 15 players that will end up being some 4,590 separate fields. I figured there must be an easier way .....
What you are posting is a "Cross tab" or "pivot table" report. If you do a search on this form, you can find descriptions of several very different ways to produce such a report. None are particularly simple to set up, but do work if you get all the details in place. It's best to look at more than one option as one may be much easier to understand than another depending on what prior skill/experience you have.