I have data that consists of two fields. One is a time stamp (date & time), the other is a number.
I need to determine the:
* number of instances data is above a certain value
* duration that data is above a certain value
I have attached a sample database. In the only table I have 4 fields
2 are as described above.
If you take the table with all four fields, this is the result I want in a query. In this instance I am looking for all data above 3
How can I created a query for this?
Thanks in advance
I need to determine the:
* number of instances data is above a certain value
* duration that data is above a certain value
I have attached a sample database. In the only table I have 4 fields
2 are as described above.
If you take the table with all four fields, this is the result I want in a query. In this instance I am looking for all data above 3
How can I created a query for this?
Thanks in advance