计算每个reg键的连续胜利 [英] count consecutive wins per reg key

问题描述

我需要根据此数据计算每个注册码的连续获胜次数（Fin Pos）。是否可以使用Access执行此操作？我是一个相当新的Access查询。


在我想要的更大的数据组中：

I need to count the number of consecutive wins(Fin Pos) per reg key from this data. Is it possible to do this with Access? I''m fairly new to Access queries.

Out of the larger group of data shown I would want:

展开 | 选择 | Wrap | 行号

推荐答案

大多数事情都是可能的，但是你没有解释你是如何想出你想要的结果的。我个人认为你想要的结果与较大的数据组之间没有相关性。


**编辑**

我想我现在可能会看到它。字段Fin Pos是完成位置，您正在查找结束位置为1的连续记录。这是正确的吗？你有一个主键领域吗？另外，如果你有两组连续获胜，你想要发生什么？例如，如果记录

Most things are possible, but you don''t explain how you came up with the result that you are looking for. I personally see no correlation between the results you are wanting and the larger data group.

**Edit**
I think that I might see it now. The field Fin Pos is Finish Position and you are looking for consecutive records where the finish position is 1. Is that correct? Do you have a primary key field? Also, what do you want to happen if you have two groups of consecutive wins? For example, what if the record

展开 | 选择 | Wrap | 行号

是的，这是对的。我想计算每匹马有多少连续完成位置1。数字字段是代表马的数字（例如：Charger Bar'的数字是614060）如果马数中有多个，那么我想要计算你在帖子中显示的两个实例。


我正在使用Access 2010。

Yes that is right. I want to count how many consecutive finish positions of 1 for each horse. the number field is a number representing the horse(ex: Charger Bar''s number is 614060) If there is more than one within a horse number then I would want to count both instances like you showed in your post.

I''m using Access 2010.

Seth，

回到origninal post数据，第二个块。

OP计算从4到13的记录，因为在14 [CHANT''s ALIBHAI]地点然后没有连续跟随那一点。

与[CHARGER BAR]相同，OP只计算22到24的记录。

如果有随后也会记录下一系列的胜利......这样他们就可以追踪连胜纪录。


标准赛马比赛的事情 - 看着我妈妈的老板这样做交上一本棕色的小书:)。

（对不起，认识这些名字 - 不过，我认为这些都是非常古老的数据，Chant'的Alibhai在70年代中后期参加比赛 - 是的？'80年代或'90年代的面包 - 似乎我记得去DelMar参加比赛并听到与马有关的名字 - 差不多30年了，所以我可能会记错了。）

从未尝试过对数据库进行操作。

Seth,
Go back to the origninal post data, second block.
OP is counting records from 4 thru 13, because at 14 [CHANT''S ALIBHAI] "place" and then doesn''t have a consecutive following that point.
Same thing with [CHARGER BAR], where OP is only counting records 22 thru 24.
If there is a subsequent series of wins then that is also usually recorded... this way they keep track of winning streaks.

Standard Horse race thing - watched my Mom''s boss do this by hand in a little brown book :).
(sorry, recognize the names - however, I think these are very old stats, Chant''s Alibhai raced in the mid to late ''70s - yes? Breading in ''80s or ''90s - Seems I remember going to the races in DelMar and hearing the name in relation to a horse - been almost 30 years so I might be mis-remembering.)
Never tried to do a DB on it.

这篇关于计算每个reg键的连续胜利的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！