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

B

bettyboopbh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top