Access 2000

Mamilovic

Guest

Posts: n/a

#1: Jan 24 '06

I have a one table of logged data, Time and Value (two fields)

TIME VALUE
01/01/05 11:00:08 1.33763
01/01/05 11:00:16 1.33238
01/01/05 11:00:24 1.32988
01/01/05 11:00:32 1.33125

I want to filter out all records above a certain value X and then only
the first record when the value goes from below to above X. Can you do
this in SQL / Sub query Help Please

Regards John

« previous question | next question »

Similar Microsoft Access / VBA bytes

Access 2000 to 2003 conversion missing reference and freezing errors (answers)
MS Access 2000 Password Recoverer (answers)
Advice needed: Should we upgrade MS Access 2000? And if so to what? (answers)
Access 2000 Stability (answers)
Access 2000 Distributing (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,546 network members.