C
camby
I am attempting to calculate the win/loss streaks up through various dates
for several different teams in an access database. The Fields I am using are
[Date], [Team], [Score], [Result] (such as W, L, T). What I would like to
get is for each team, on each date, to calculate the win/loss streak. Thus
if a team has won two games consecutively through 6/11, it would result in a
W2. If they win again on 6/12 it would result in W3. A loss would obviously
result in L1.
I've checked other posts, and almost everything was done either in Excel or
was only looking for the longest streak to date.
for several different teams in an access database. The Fields I am using are
[Date], [Team], [Score], [Result] (such as W, L, T). What I would like to
get is for each team, on each date, to calculate the win/loss streak. Thus
if a team has won two games consecutively through 6/11, it would result in a
W2. If they win again on 6/12 it would result in W3. A loss would obviously
result in L1.
I've checked other posts, and almost everything was done either in Excel or
was only looking for the longest streak to date.