|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
August 15th, 2003, 08:45 AM
|
|||
|
|||
|
msaccess - query with time range
I have a table which contains data readings taken every 90 seconds. I need help defining a query that will allow me to report on instances of data being below a given level for a period greater than an hour, ie if the data reading only drops below a level for ten minutes I'm not bothered but if it drops below a level for longer than 60 minutes I need it to be displayed.
 please help........ ta gg
|
|
#2
August 29th, 2003, 02:37 PM
|
||||
|
||||
|
Please wait I will let you know tomorrow
I have to create a sample data to check it out myself. It is easy to do thru vbprogramming in module. But by query I will try it and reply as soon as possible.
V.Subramanian subbu@roots.co.in supersubra@hotmail.com
__________________
V.Subramanian
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > msaccess - query with time range |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
