How can I count the occurrence of a word from a different table(table 2) field by comparing it with table1 field value?

Question

0.00/5 (No votes)

See more:

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]*"

Posted 15-Aug-16 6:09am

Danyal Awan

Updated 15-Aug-16 8:03am

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-08-15T08:03:00

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:

SQL

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

How can I count the occurrence of a word from a different table(table 2) field by comparing it with table1 field value?

1 solution

Solution 1

Add your solution here

Preview 0

How can I count the occurrence of a word from a different table(table 2) field by comparing it with table1 field value?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us