Find consecutive number of records in DB!

[fxp]

Hello,
I am trying to generate some query result on a form.
My DB consists of the following fields : tradeID and profit/loss.
How do i make a query to find the Maximum consecutive number of wins and losses in the database and display the results on a form?


Would really appreciate it if any of you have tried to sort and display results for finding consecutive number of events in any database!


Thanks a lot

 

[fxp]

Does anyone here have a solution for this??
Would appreciate any help from you guys.

Cheers

 

[Pat Hartman]

I don't think that you can do this with SQL. You'll need to write a code loop that counts the groups of records. Open a recordset based on a query ordered by the autonumber to ensure data entry sequence.