如何通过将其与table1字段值进行比较来计算不同表（表2）字段中单词的出现次数？ [英] How can I count the occurrence of a word from a different table(table 2) field by comparing it with table1 field value?

问题描述

我想计算表1字段中单词的出现，而不是将它与表2的字段进行比较，表明发生了多少时间，并将其存储在表1中。我想在MS ACCESS中使用它。我有一个表（差距摘要），我有一个字段（数据域），我有另一个表（TOC数据元素），因为我有一个字段（域）。字段（Data Domain）是唯一的但Field（Domain）不是。字段（Domain）具有多个相似的值。我希望从Field（Data Domain）获得价值，例如预先指令，并在Field（Domain）中检查它是否在那里发生了多少次预先指令。假设它发生了4次，而不是我希望表中的这个值（差距摘要）字段（数据元素的总数）



我尝试过：



喜欢* [表名]。[列名] *

喜欢* [差距摘要]。[数据Domain] *

I want to count the occurrence of word from a field of table 1 than compare it with a field of table 2 that how much time it occurred and than store it in table 1. I want this in MS ACCESS.I have a Table (Gap Summary) in that I have a Field (Data Domain) and I have another Table (TOC Data Elements) in that I have a Field (Domain). Field (Data Domain) is unique but Field (Domain) is not.. Field (Domain) has multiple similar values. I want to get value from Field (Data Domain) e.g Advance Directives and check it in Field (Domain) that how many time Advance Directives occurred there. Suppose it occurred 4 time than I want this value in Table (Gap Summary) Field (Total # of Data Elements)

What I have tried:

Like "*[table name].[column name]*"
Like "*[Gap Summary].[Data Domain]*"

推荐答案

喜欢用字符串操作：这就是你给它的东西。所以它正在寻找任何东西，然后是文本[table name]。[column name]，后跟其他任何东西。这不是列的 内容 ，它是文本[表名]。[列名]。

查找内容列，请尝试：

Like operates with a string: and that's what you are giving it. So it's looking for anything, followed by the text "[table name].[column name]", followed by anything else. That's not the content of the column, it's the text "[table name].[column name]".
To look for the content of a column, try:

LIKE "*" + [table name].[column name] + "*"

这篇关于如何通过将其与table1字段值进行比较来计算不同表（表2）字段中单词的出现次数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！