statistics: How many days in a row...?

[Fuga]

I have a table showing the highest temperature in a room during the day.

I want to be able to calculate how many days in a row, on average, the temperature rises above a certain temperature.

Fuga.

 

[llkhoutx]

I would cycle through the table use DAO to count the consecutive days.

 

[Fuga]

Ok. That sounds a bit out of my league, but I´ll give it a try.

Fuga.

 

[DH]

Try this link as well
http://www.mvps.org/access/queries/qry0018.htm