On Jan 5, 4:39*pm, "Clifford Bass via AccessMonster.com" u48370@uwe
wrote:
Hi,

* * *Just to be su Is that per day? *Or across all days? *Do you want all
of the streaks? *Or just the longest? *Is that just the longest of either
winning or losing? *Or the longest of both? *Is a single win or loss really a
streak? *That seems to be contradictory. *Can a player play more than one
game at once? *Do later games always have higher GameIDs then earlier games?
Other factors of importance?

* * * * * * Clifford Bass





pat67 wrote:
Wow. let me clarify more if I can. I just used 3 as an example. If a
players longest winning streak is 1 or 100, that's what I want to
show.

My data table has these fields:

GameID * *Date * *Winner * *Loser

I then have a union query with these fields:

Date GameID Player * Opponent *Result

result being Won or Lost

So that means that there are 2 results for each game id.

does that make it easier?

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201001/1- Hide quoted text -

- Show quoted text -

longest streak. GameID is from an autonumber field in my table so it
is always increasing. 1 is a winning streak, yes technically.