Welcome to SPN

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

Sign Up Now!

how do i count consecutive records with a field value >=1, --

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

  1. bettyboopbh

    bettyboopbh
    Expand Collapse
    Guest

    restarting count after a record with a field value <1. (count should be
    based on query order OR form order of records, not the order of the records
    in their table.) I DON'T KNOW VISUAL BASIC, SO IF IT'S POSSIBLE I WANT TO
    USE an EXPRESSION IN A QUERY OR ON A FORM.
    i.e.
    field
    date value count THANK YOU.
    6/1/06 2 1
    6/2/06 8 2
    6/3/06 4 3
    6/4/06 0 0
    6/5/06 6 1
    6/6/06 9 2
    6/7/06 -23 0
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---The Accountant Theatre, Movies & Cinema Oct 21, 2016
    Gurmat Vichaar | Futility Of Counting Paaths | April 12, 2016 Gurmat Vichaar Apr 23, 2016
    wolf count Blogs Oct 17, 2015
    recount Blogs Oct 17, 2015
    Events Banda Singh Bahadur's Martyrdom - An Eyewitness Account History of Sikhism Mar 26, 2015

Share This Page