game score calculations

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,