Forum Discussion

Aleksandar444's avatar
Aleksandar444
Copper Contributor
Apr 21, 2022

Count score between two players from lot of online games

My friends and me are playing some online card games. That is game for 4 players and at the end server saves result of all games. I can copy all games in excel and I already did some adjustments of data. For example, I got results in this format:

0-2336555 // unique number of game

John  12

Ana   25

Dana  33

Peter  36

For result we got points for each games (10-6-3-1). I have all of that sorted as it can be seen in example in attach. Now, we want to know mutual score between two players.

On some our forum nice people helped me and I got that in excel in Power query (SHEET Poredjenje in my workbook). But, there is only counted score for results on the end of game (John - Ana; 12 -25; it means 1-0 for John) but I want also to know how many points got each player in mutual games (John - Ana; 12-25; 10 -6 in upper example) and I want it in Access.

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    What is your question? Do you want to create an Access relational database application in which to store and manage this data?

Resources