Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

calculate win/loss streak

Discussion in 'Information Technology' started by camby, Jul 28, 2006.

  1. camby

    camby
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    India Reading Calculated Banis Breaking News Mar 6, 2013

Share This Page