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.

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

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

Fuga.

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