Mr. Chamberlain Posted March 27, 2005 Posted March 27, 2005 I have a simple database to track the scores of a card game between 2 players. For this example, the 2 players are always the same. The card game has eleven hands to each game. My set up is: One table. A repeating field for each players score for each hand. A summary for each players hand-scores to calculate the game total. The database recognizes the winner based on the highest score- it also totals the number of wins for each player. As a side note, only one player per hand can score, so if one player has any score, the other players score for that hand will always be zero. I have a record for each game, they have serial numbers based on the order in which they were played, also coded by date. Here's what I can't figure out: I want to know the most games a player has won in a row; I can't figure out the calculation or formula to give me this. I also want to calculate the most hands won in a row among all the games. Any suggestions or have I left out pertinent info? Thanks,
Recommended Posts
This topic is 7249 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now