Access 2000

January 24th, 2006, 10:25 AM

Mamilovic

Guest

Posts: n/a

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 Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access 2000 to 2003 conversion missing reference and freezing errors	NEWSGROUPS	answers	3	December 5th, 2007 05:05 AM
MS Access 2000 Password Recoverer	com	answers	0	November 13th, 2005 03:06 PM
Advice needed: Should we upgrade MS Access 2000? And if so to what?	ship	answers	47	November 13th, 2005 11:39 AM
Access 2000 Stability	Serious_Practitioner	answers	6	November 13th, 2005 02:30 AM
Access 2000 Distributing	Scott	answers	2	November 12th, 2005 05:33 PM

/bytes/development

/bytes/it

/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 225,662 network members.