访问2000 [英] Access 2000
问题描述
我有一个记录数据表,时间和价值(两个字段)
时间价值
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
我想过滤掉某个值X以上的所有记录然后只有
当值的第一个记录从下面到上面的X.你可以在SQL /子查询中做这个吗?/ b $ b请帮助
问候约翰
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
推荐答案
Mamilovic写道:
Mamilovic wrote:
我有一个记录数据表,时间和价值(两个字段)
时间价值
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
我想过滤掉某个值X以上的所有记录,然后只有当值来自时的第一个记录你可以在SQL /子查询帮助中做到这一点吗
关心John
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
John,
这看起来像一个有趣的问题,我有信心有人
这里可以帮到你,但目前还不清楚你是什么
试图做。我不想花时间疯狂猜测。
请提供记录数据表的名称,更改名称
字段TIME和对于不会混淆SQL的名称,以及大多数重要的
,提供了一个更详细的例子,说明你想要做什么,包括你想要的输出样本获得。
我希望这会有所帮助,
James A. Fortune
CD ******** @ FortuneJames.com
John,
This looks like an interesting problem that I feel confident someone
here can help you with, but it is not yet clear to me what you are
trying to do. I don''t want to spend time on a wild guess chase.
Please provide the name of the table of logged data, change the name of
the fields TIME and VALUE to names that will not confuse SQL and, most
importantly, provide a more detailed example of what you are trying to
do, including a sample of the output you want to obtain.
I hope this helps,
James A. Fortune
CD********@FortuneJames.com
谢谢你回复
表名是DataLogged,样本数据如下所示。
Thanks for replying
Table name is DataLogged and sample data is shown below.
TIMESTAMP READING
01/01/05 11:00:08 1.4
01 / 01/05 11:00:16 1.5
01/01/05 11:00:24 1.6
01/01/05 11:00:32 1.3
01/01/05 11 :00:40 1.4
01/01/05 11:00:48 1.5
01/01/05 11:00:56 1.5
01/01/05 11 :01:04 1.5
01/01/05 11:01:12 1.5
如果X是1.45,我想看到的回复将是01/01 / 05 11:00:16 1.5
01/01/05 11:00:48 1.5
TIMESTAMP READING
01/01/05 11:00:08 1.4
01/01/05 11:00:16 1.5
01/01/05 11:00:24 1.6
01/01/05 11:00:32 1.3
01/01/05 11:00:40 1.4
01/01/05 11:00:48 1.5
01/01/05 11:00:56 1.5
01/01/05 11:01:04 1.5
01/01/05 11:01:12 1.5
The reords which I want to see, if X was 1.45 would be 01/01/05 11:00:16 1.5
01/01/05 11:00:48 1.5
John
John
>
Mamilovic写道:
Mamilovic wrote:
感谢您的回复
表名是DataLogged,样本数据如下所示。
Thanks for replying
Table name is DataLogged and sample data is shown below.
TIMESTAMP READING
01/01 / 05 11:00:08 1.4
01/01/05 11:00:16 1.5
01/01/05 11:00:24 1.6
01/01/05 11:00 :32 1.3
01/01/05 11:00:40 1.4
01/01/05 11:00:48 1.5
01/01/05 11:00:56 1.5
01/01/05 11:01:04 1.5
01/01/05 11:01:12 1.5
TIMESTAMP READING
01/01/05 11:00:08 1.4
01/01/05 11:00:16 1.5
01/01/05 11:00:24 1.6
01/01/05 11:00:32 1.3
01/01/05 11:00:40 1.4
01/01/05 11:00:48 1.5
01/01/05 11:00:56 1.5
01/01/05 11:01:04 1.5
01/01/05 11:01:12 1.5
我希望看到的reords,如果X 1.45将是
The reords which I want to see, if X was 1.45 would be
01/01/05 11:00:16 1.5
01/01/05 11:00:48 1.5
01/01/05 11:00:16 1.5
01/01/05 11:00:48 1.5
Joh n
John
我明白你现在要做什么。如果没有其他人发布解决方案,我明天下午应该为你提供一个解决方案。它应该只花费大约几分钟才能完成和测试,但我现在必须离开。
James A. Fortune
CD ******** @ FortuneJames.com
I see what you are trying to do now. If no one else posts a solution I
should have one for you tomorrow afternoon. It should only take about
ten minutes to do and test but I have to leave right now.
James A. Fortune
CD********@FortuneJames.com
这篇关于访问2000的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!