Calculate Duration Data Above Value

TimTDP

Registered User.
Local time
Today, 21:32
Joined
Oct 24, 2008
Messages
213
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
 

Attachments

Users who are viewing this thread

Back
Top Bottom