功能类似于Access中的VLookup？ [英] Function Similar to VLookup in Access?

问题描述

我有一个数据表，其中每一行都包含一个唯一的数字。为了重新排列数据并合并各行，我不得不删除这个唯一的数字并使用2个交叉表查询加入表。

I have a table of data where each row contains a unique number. In order to rearrange the data and merger various rows, I have had to remove this unique number and join the table with 2 crosstab queries.

但是，现在我需要带回至少一个唯一的号码。例如：

However, now I need to bring back at least one unique number. For example:

唯一编号 参考
付款类型 预期付款
实际付款 

Unique Number Reference Payment Type Expected Payment Actual Payment 

12743234                3546575
DD 10
5

12743234                3546575 DD 10 5

12743235 3546575
现金 20
15

12743235 3546575 Cash 20 15

我已根据参考将两条线合并在一起，现在我需要带回12743234或12743235.如果我是在excel中使用vlookup公式，它将返回第一个。这可以在sql中做吗？我试过Dlookup，但它没有
工作。

I have merged the two lines together based on the reference, now I need to bring back either 12743234 or 12743235. If I were to use a vlookup formula in excel, it would return the first one. Is this possible to do in sql? I tried Dlookup but it hasn't worked.

推荐答案

Dlookup就是答案。我已经多次使用它了。但是它不适合大型数据集，因为它很慢。对于较大的数据集，请创建查询。

Dlookup is the answer. I've used it many times. However it isn't suitable for large data sets as its slow. For larger datasets, create a query.

这篇关于功能类似于Access中的VLookup？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！