I have a simple table with two fields - time and data reading. The data readings are taken every 90 sec and I would like to report on instances where the data readings are below a certain level for a period of 60 mins or greater, ie if the reading drops below my level for ten minutes I'm not bothered but if it drops below (and stays below) my level for 60 mins I am.
please help