比较另一个记录集中两个记录集/查找记录集值之间的数据 [英] Compare data between two recordsets / lookup recordset value in another recordset

问题描述

正如标题所示，我创建了记录集（1：当前年份，2：前一年）

我只是希望能够执行以下操作：

1-by-1查找去年的id /值并将信息拉回显示它与Debug.Print。


从那里我想我知道怎么写这个数据到一个数组。

As the title suggets, I have created to recordsets (1: current year, 2: previous year)
I simply want to be able to do the following:
1-by-1 lookup an id/value in last year and pull the information back displaying it with Debug.Print.

from there I think i know how to write this data to an array.

推荐答案

我目前的代码如下：

the code I currently have is as follows:

展开 | 选择 | Wrap | 行号

除非我误解了您的请求，否则请创建一个Re直接从过滤器串行显示结果，如下所示：

Unless I am misinterpreting your request, create a Recordset directly from the Filter and display the results, as in:

展开 | 选择 | Wrap | 行号

感谢您的回复。我想搜索另一个记录集或数组。让我给你举个例子。我有一个名为Athlete2013的记录集和另一个名为Athlete 2012的记录集。

查看下面的记录集，我想从Recordset_Athlete2013获取Mo Farah并在Recordset_Athlete2012中搜索他。找到他之后，我想展示他的位置。所以作为最终输出，我将有类似下面的内容。我希望这很清楚。我希望能够为Recordset_Athlete2013中的每条记录执行此操作。

Thanks for the reply. I want to search another recordset or array though. let me give you an example. I have a recordset called Athlete2013 and another recordset called Athlete 2012.
Looking at the below recordsets, I want to take Mo Farah from Recordset_Athlete2013 and search for him in Recordset_Athlete2012. Having found him, I want to to display his position. So as a final output I will have something like below. I hope this is clear. I want to be able to do this for each record in Recordset_Athlete2013.

展开 | 选择 | Wrap | 行号

这篇关于比较另一个记录集中两个记录集/查找记录集值之间的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！