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.