Help extracting data

[mikajake]

Hi there I am having a problem with this report I am trying to generate.

From the table supplied, I am trying to produce a single list as supplied:

Screen 1

Screen 2

I am thinking with some scripting and variables I can achieve this.

Thanks,

Mika

[Vaughan]

I'd say your problem is that each record contains fields for 3 games. These should in a "Game" table where each record is a single game.

Once this is done the report will just fall out the way you want.